-
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
-
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
-
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.
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|