Hi experts,



I've one production db running on oracle9i. I've gathered few statspack
reports for 1 week period. The buffer hit ratio is consistently on
average of 60%-65%.

Output for other portion also same from one report to another. Here are
some info of the report:



Buffer Cache: 3,200M



Instance Efficiency Percentages (Target 100%)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Buffer Hit %: 64.41



Top 5 Timed Events

~~~~~~~~~~~~~~~~~~ %
Total

Event Waits Time (s)
Ela Time

-------------------------------------------- ------------ -----------
--------

CPU time 14,188
75.98

db file scattered read 26,370,930 2,287
12.25

sbtbackup 7 592
3.17

log file parallel write 247,490 464
2.49

db file sequential read 21,432,275 386
2.07



Kindly advice on what should I do next.



Thanks and Best Regards,

Shahrir Ibaruslan




Oracle LazyDBA home page