Is "Physical Reads" too slow for this DB instance?
Hi Experts,
Could you help to see if this DB instance has problem of I/O performance, this is not about improve execution plan so less IO is required. Please strictly look into I/O performance.
My calculation is that DB is reading from datafiles at 1.35 MB/second.
Here is related section of AWR report
Thank you very much
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 725 20-Jan-14 23:25:50 31 1.3
End Snap: 744 21-Jan-14 17:02:30 31 1.5
Elapsed: 1,056.66 (mins)
DB Time: 1,068.49 (mins)
Load Profile
Per Second Per Transaction Per Exec Per Call
DB Time(s): 1.0 1.8 0.14 2.92
DB CPU(s): 0.0 0.1 0.01 0.13
Redo size: 1,592.3 2,778.2
Logical reads: 526.8 919.2
Block changes: 9.7 17.0
Physical reads: 169.4 295.6
Could you help to see if this DB instance has problem of I/O performance, this is not about improve execution plan so less IO is required. Please strictly look into I/O performance.
My calculation is that DB is reading from datafiles at 1.35 MB/second.
Here is related section of AWR report
Thank you very much
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 725 20-Jan-14 23:25:50 31 1.3
End Snap: 744 21-Jan-14 17:02:30 31 1.5
Elapsed: 1,056.66 (mins)
DB Time: 1,068.49 (mins)
Load Profile
Per Second Per Transaction Per Exec Per Call
DB Time(s): 1.0 1.8 0.14 2.92
DB CPU(s): 0.0 0.1 0.01 0.13
Redo size: 1,592.3 2,778.2
Logical reads: 526.8 919.2
Block changes: 9.7 17.0
Physical reads: 169.4 295.6
0