Hi All,
11.2.0.1
Aix 6.1
I got this awr top events report.
Can you help me how to interpret this please. Or what value to watch out here? Thanks a lot
AWR Top Events Report
i
n
Snap s Snap A
Snap Start t Dur Event Time Avgwt DB Time A
ID Time # (m) Event Rank Waits (s) (ms) % S Wait Class
------ --------------- --- ---------- ---------------------------------------- ----- -------------- -------------- -------- ------- ------ ---------------
13902 13/09/16 09:00 1 60.05 os thread startup 1 140.00 11.08 79.11 56 0.0 Concurrency
13902 13/09/16 09:00 1 60.05 CPU time 2 0.00 9.45 0.00 48 0.0 CPU
13902 13/09/16 09:00 1 60.05 log file parallel write 3 1506.00 1.84 1.22 9 0.0 System I/O
13902 13/09/16 09:00 1 60.05 control file parallel write 4 1291.00 1.41 1.09 7 0.0 System I/O
13902 13/09/16 09:00 1 60.05 log file sync 5 721.00 1.03 1.43 5 0.0 Commit
13903 13/09/16 10:00 1 60.05 os thread startup 1 138.00 10.36 75.10 47 0.0 Concurrency
13903 13/09/16 10:00 1 60.05 CPU time 2 0.00 10.28 0.00 47 0.0 CPU
13903 13/09/16 10:00 1 60.05 log file parallel write 3 1575.00 1.73 1.10 8 0.0 System I/O
13903 13/09/16 10:00 1 60.05 direct path read 3 486.00 1.73 3.56 8 0.0 User I/O
13903 13/09/16 10:00 1 60.05 control file parallel write 4 1285.00 1.51 1.17 7 0.0 System I/O
13903 13/09/16 10:00 1 60.05 log file sync 5 823.00 1.08 1.32 5 0.0 Commit
13904 13/09/16 11:00 1 60.05 CPU time 1 0.00 17.06 0.00 32 0.0 CPU
13904 13/09/16 11:00 1 60.05 os thread startup 2 145.00 10.65 73.46 20 0.0 Concurrency