Database Tuning (MOSC)

MOSC Banner

How to tune when there is high I/O

edited Aug 28, 2012 10:30PM in Database Tuning (MOSC) 6 commentsAnswered
Hi

My Awr shows there is I/O is High on few querys, how do i need to tune by database and the querys

Redologs are not in Raid 5   and the size of redolog is 100MB ( if i need to increase the size how do i need to find out what size  i need to increase)


   Physical              Reads              Elapsed
      Reads  Executions per Exec   %Total   Time (s)   %CPU    %IO    SQL Id
----------- ----------- ---------- ------ ---------- ------ ------ -------------
      4,945           2    2,472.5   12.7      676.0     .1   99.9 4abchk2bsb0tt
Module: SAPLSCCR
SELECT "TABNAME" , "TABCLASS" , "SQLTAB" , "CLIDEP" , "CONTFLAG" FROM "DD02L" WH
ERE "AS4LOCAL" = :A0 AND "TABCLASS" IN ( :A1 , :A2 , :A3 )

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