High Disk Reads and Buffer Gets
554899Dec 5 2007 — edited Jan 3 2008Hi,
I'm facing a problem with high disk reads and high buffer gets since I applied a new oracle pl/sql package on the server. Following are the stats-
Executions
Total 13
Per Execution 1
Per Row 1.00
CPU Time (sec)
Total 79,473.43
Per Execution 6,113.34
Per Row 6,113.34
Buffer Gets
Total 1,078,014,351
Per Execution 82,924,180.85
Per Row 82,924,180.85
Disk Reads
Total 12,029,497
Per Execution 925,345.92
Per Row 925,345.92
DBA is asking to review the package for possible performance tuning but it seems not possible to change the code. Any suggestions how the performance can be improved?