Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,267 views