Buffer gets / disk reads
Hi,
Are the following values for few queries causing slowness in my system? I get the following for one query from Top SQL in OEM.
Disk Reads Per Execution :85110
Buffer Gets Per Execution : 7919817
Buffer Gets Per Row: 6845.131374
Buffer Cache Hit Ratio : 98.925354
Shareable Memory : 12051
Rows processed :1157
Runtime Memory : 43860
CPU time: 25296875
Elapsed Time : 32510620
----------------------------------------------------
My DB version is: 9.2.0.8
db_block_buffers value is : 1400000
db_block_size = 8192
shared_pool_size = 268435456 (256 MB)
I see "db file sequential read" or "db file scattered read" are the events when this happens..
Please advise me how do I decide that query is causing the slowness?
0