Database Tuning (MOSC)

MOSC Banner

Is "Physical Reads" too slow for this DB instance?

edited Jan 23, 2014 11:27PM in Database Tuning (MOSC) 5 commentsAnswered
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          

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center