Oracle Database Discussions

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 issue - buffer cache hit ratio below 50%

user480060Mar 6 2007 — edited Jul 10 2007

Dear all

db block gets = 5938
consistent gets = 13632900
physical reads = 9737847

hit ration is about 27%.

please suggest some solution.

Waiting for your answer
SL

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2007

Added on Mar 6 2007

#general-database-discussions

33 comments

27,243 views