Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance Hit Ratios

RengudiMar 3 2009 — edited Mar 4 2009
Hi

I would like calculate the following hit ratios against my instance performance metrics

1.Buffer Cache Hit %
2.Library Cache Hit %
3.Redo No Wait %
4.Memory Sort %
5.Soft Parse %
6.Commit %

And I need to know what would be the optimal values against this hit ratio for 900 GB database with Aix 5.3 platform.
if i dont have optimal values with query results. What are all the parameter should i need to tune and how much i need to tune?

Kindly help me on this.

Thanks
Ranga
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2009
Added on Mar 3 2009
19 comments
1,390 views