DB Performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: DB Performance

  1. #1
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    When users start complaining about the db performance what are the key areas we need to look other than db hit ratios.

    Also can somebody give me some guide lines to pro-actively monitor the database.

    Thanks

  2. #2
    Join Date
    Jun 2002
    Posts
    3

    Talking DB Performance

    Please check the V$ACCESS dynamic performance view to see what are the current database objects accessed and also query the dynamic performance view V$SQLAREA to see what the current sql running in the SGA and then proceed accrodingly.

    Thanks,
    Suvendu
    Suvendu Das
    Cognizant Technologies Solution
    Phone : 357-3211/3212/3213 ext. 1443/1446

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    1st goal and usually most significant performance gain is to Tune SQL.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    As Sureshy says the best performance gains will come from tuning your SQL code. If you are looking at overall performance it may be advisable to run statspack on the DB for a couple of hours to give you a generally overview of potential problem areas.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    As jovery has said, statspack is an excellent performance and bottleneck indicator. Another good thing about statspack is that you will be shown the top ten most resource consuming sql statements.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width