This is not a real database snapshot but set of demo screenshots. Please allow some inaccuracy in numbers and dates.

[02/17/12 05:37:27pm]    Database: rdemo16    Instance: #2 rdemo162    rrac16b.obzora.prv    10.2.0.4.0    Uptime: 10 days 18 hours 20 minutes

System Events

Class Event Total
Waits
Total
Timeouts
Time
Waited, s
Average
Wait, s
User I/O DG Broker configuration file I/O 4 0 0.00 0.000
User I/O db file parallel read 24917 0 292.48 0.012
User I/O db file scattered read 3431790 0 62320.91 0.018
User I/O db file sequential read 135644855 0 859311.06 0.006
User I/O db file single write 1677 0 3.58 0.002
User I/O direct path read 251545 0 336.11 0.001
User I/O direct path read temp 329188 0 2899.01 0.009
User I/O direct path write 70212 0 98.55 0.001
User I/O direct path write temp 801897 0 54494.86 0.068
User I/O local write wait 45491 28 2035.68 0.045
User I/O read by other session 22950539 1803 434118.70 0.019
Commit log file sync 3790205 1372 19805.30 0.005
System I/O Log archive I/O 295772 0 4494.07 0.015
System I/O RMAN backup & recovery I/O 2715811 0 33479.50 0.012
System I/O control file parallel write 464608 0 1576.92 0.003
System I/O control file sequential read 11581928 0 14934.76 0.001
System I/O control file single write 970 0 4.45 0.005
System I/O db file parallel write 6894387 0 28259.18 0.004
System I/O kst: async disk IO 10190 0 0.33 0.000
System I/O log file parallel write 5038037 0 13393.30 0.003
System I/O log file sequential read 7976629 0 13014.53 0.002
System I/O log file single write 2788 0 4.76 0.002
System I/O recovery read 45 0 0.00 0.000
Concurrency buffer busy waits 2659427 154332 172565.87 0.065
Concurrency cursor: mutex S 5433 0 0.10 0.000
Concurrency cursor: mutex X 704774 0 2.42 0.000
Concurrency cursor: pin S wait on X 2456376 2431994 27139.19 0.011
Concurrency enq: TX - index contention 28959 4605 3416.74 0.118
Concurrency latch: cache buffers chains 14687226 0 22027.52 0.002
Concurrency latch: library cache 661856 0 5771.99 0.009
Concurrency latch: library cache lock 32135 0 102157.77 3.179
Concurrency latch: library cache pin 87479 0 123.47 0.001
Concurrency latch: row cache objects 414467 0 734.60 0.002
Concurrency latch: shared pool 469030 6 3600.81 0.008
Concurrency library cache load lock 8860 591 3378.53 0.381
Concurrency library cache lock 72121 65 280.31 0.004
Concurrency library cache pin 39693 1 52.88 0.001
Concurrency os thread startup 8789 152 425.26 0.048
Concurrency row cache lock 579672 35 1271.38 0.002
Application SQL*Net break/reset to client 19992672 0 8833.14 0.000
Application enq: PW - flush prewarm buffers 137 0 0.16 0.001
Application enq: RO - fast object reuse 1158 1 4.75 0.004
Application enq: TM - contention 74527 51967 25534.60 0.343
Application enq: TX - row lock contention 4055543 4048612 1983873.88 0.489
Application enq: UL - contention 153 0 0.09 0.001
Configuration checkpoint completed 19 0 0.42 0.022
Configuration enq: HW - contention 4921805 317 3360.07 0.001
Configuration enq: SQ - contention 2128 9 343.67 0.162
Configuration enq: SS - contention 86215 75547 38722.20 0.449
Configuration enq: TX - allocate ITL entry 405 23 30.24 0.075
Configuration latch: redo writing 159 0 0.30 0.002
Configuration log buffer space 4268 0 8.62 0.002
Configuration log file switch (checkpoint incomplete) 1 0 0.01 0.012
Configuration log file switch completion 11334 10 342.69 0.030
Configuration undo segment extension 4026857 4025907 33.20 0.000
Configuration write complete waits 1 1 0.98 0.977
Administrative index (re)build online cleanup 2022 389 38.50 0.019
Administrative switch logfile command 73 0 3.47 0.048
Cluster gc buffer busy 5702381 56870 110919.75 0.020
Cluster gc cr block 2-way 784620 0 368.08 0.001
Cluster gc cr block busy 485860 0 2259.11 0.005
Cluster gc cr block congested 8 0 0.09 0.011
Cluster gc cr disk read 6342533 0 4446.05 0.001
Cluster gc cr failure 334 0 0.12 0.000
Cluster gc cr grant 2-way 3419818 1 1415.02 0.000
Cluster gc cr grant congested 1 0 0.00 0.002
Cluster gc cr multi block request 1104907 3 468.86 0.000
Cluster gc current block 2-way 787337 4 714.09 0.001
Cluster gc current block busy 83335 0 2326.29 0.028
Cluster gc current block congested 2 0 0.04 0.019
Cluster gc current block unknown 99 0 0.07 0.001
Cluster gc current grant 2-way 2336032 0 1538.41 0.001
Cluster gc current grant busy 154084 0 312.90 0.002
Cluster gc current grant congested 1 0 0.07 0.070
Cluster gc current multi block request 330053 0 132.82 0.000
Cluster gc current retry 1267 33 56.57 0.045
Cluster gc current split 178 0 1.81 0.010
Cluster gc domain validation 27 16 45.21 1.674
Cluster gc object scan 17 14 0.04 0.003
Cluster gc quiesce 4 0 0.00 0.000
Cluster gc remaster 203 0 5.78 0.029
Network ARCH wait for netserver start 2 2 7.82 3.908
Network ARCH wait on ATTACH 10 0 0.59 0.059
Network ARCH wait on DETACH 10 0 0.02 0.002
Network ARCH wait on SENDREQ 134 0 95.42 0.712
Network LGWR wait on LNS 6 0 0.22 0.036
Network LNS wait on ATTACH 16 0 1.43 0.089
Network LNS wait on DETACH 16 0 0.03 0.002
Network LNS wait on LGWR 10 0 0.00 0.000
Network LNS wait on SENDREQ 447414 0 53752.15 0.120
Network SQL*Net message to client 904884173 0 1542.74 0.000
Network SQL*Net more data from client 47015480 0 509.87 0.000
Network SQL*Net more data to client 322938 0 7.15 0.000
Other ARCH wait for process death 1 1 1 0.98 0.978
Other ARCH wait on c/f tx acquire 2 21 21 20.54 0.978
Other CGS wait for IPC msg 28251191 28241197 137.62 0.000
Other DFS lock handle 4593044 1209 5509.72 0.001
Other GV$: slave acquisition retry wait time 2 2 1.96 0.978
Other IPC send completion sync 78035 77525 62.71 0.001
Other KJC: Wait for msg sends to complete 9500 0 1.53 0.000
Other LGWR wait for redo copy 101827 4513 86.02 0.001
Other LGWR-LNS wait on channel 1116 1110 11.97 0.011
Other PX Deq Credit: send blkd 290216 169381 99.73 0.000
Other PX Deq: Signal ACK 265099 87133 137.00 0.001
Other PX Deq: Test for msg 495 0 0.50 0.001
Other PX Deq: reap credit 4648603 4350354 154.88 0.000
Other PX qref latch 19115 18823 0.05 0.000
Other SGA: allocation forcing component growth 605 504 6.52 0.011
Other Streams AQ: qmn coordinator waiting for 342 340 1839.05 5.377
Other Wait on stby instance close 5 5 4.89 0.977
Other buffer deadlock 90953 87853 17.14 0.000
Other buffer exterminate 9 3 3.31 0.368
Other control file heartbeat 1 1 3.91 3.907
Other cr request retry 321 314 235.65 0.734
Other cursor: pin S 3143198 0 91.09 0.000
Other cursor: pin X 431 427 4.82 0.011
Other enq: AF - task serialization 306 0 0.42 0.001
Other enq: AS - service activation 7 0 0.00 0.000
Other enq: BR - file shrink 653 0 0.28 0.000
Other enq: CF - contention 98963 4181 3049.56 0.031
Other enq: CN - race with init 3 0 0.00 0.000
Other enq: CT - state 82 0 0.04 0.001
Other enq: CU - contention 13 0 1.07 0.083
Other enq: DL - contention 68 0 0.02 0.000
Other enq: DR - contention 570 0 0.69 0.001
Other enq: FB - contention 75156 0 122.08 0.002
Other enq: FU - contention 280 278 136.73 0.488
Other enq: IR - contention 318 0 0.13 0.000
Other enq: JQ - contention 1070780 2 684.61 0.001
Other enq: JS - job recov lock 261 0 0.07 0.000
Other enq: JS - job run lock - synchronize 573 0 0.78 0.001
Other enq: JS - queue lock 13 0 0.22 0.017
Other enq: JS - wdw op 2 0 0.08 0.041
Other enq: MD - contention 75 0 0.02 0.000
Other enq: MR - contention 75 0 0.01 0.000
Other enq: PE - contention 62 4 31.77 0.513
Other enq: PG - contention 402 9 6.69 0.017
Other enq: PI - contention 34 0 0.02 0.001
Other enq: PR - contention 6 0 0.23 0.038
Other enq: PS - contention 329774 338 387.78 0.001
Other enq: RF - atomicity 6 0 0.19 0.032
Other enq: RF - synch: DG Broker metadata 19 11 5.73 0.302
Other enq: RS - prevent aging list update 133 0 0.08 0.001
Other enq: RS - prevent file delete 27164 0 12.06 0.000
Other enq: RS - read alert level 3 0 0.00 0.000
Other enq: RT - contention 3 0 0.00 0.000
Other enq: SK - contention 154 0 0.05 0.000
Other enq: SR - contention 1 0 0.00 0.001
Other enq: TA - contention 6949 0 9.04 0.001
Other enq: TC - contention 1290 47 37.55 0.029
Other enq: TD - KTF dump entries 1430 88 52.61 0.037
Other enq: TO - contention 2137 0 6.47 0.003
Other enq: TQ - INI contention 1 0 0.09 0.086
Other enq: TQ - TM contention 847 0 1.58 0.002
Other enq: TS - contention 90389 79433 39860.78 0.441
Other enq: TT - contention 1101 0 0.94 0.001
Other enq: TX - contention 830 20 46.29 0.056
Other enq: US - contention 1401614 7942 20871.84 0.015
Other enq: WF - contention 4466 425 259.53 0.058
Other enq: WL - contention 702 228 117.79 0.168
Other enq: WP - contention 1 0 0.00 0.000
Other enq: WR - contention 736 0 2.17 0.003
Other gcs drm freeze in enter server mode 366 0 21.82 0.060
Other gcs log flush sync 589160 172956 1323.20 0.002
Other gcs resource directory to be unfrozen 28 0 0.62 0.022
Other ges LMON to get to FTDONE 314 96 3.56 0.011
Other ges cgs registration 2 2 0.39 0.196
Other ges enter server mode 4 0 0.57 0.142
Other ges global resource directory to be froz 1723 1689 16.83 0.010
Other ges inquiry response 908939 45 1524.24 0.002
Other ges lmd and pmon to attach 1 0 0.00 0.004
Other ges lmd/lmses to freeze in rcfg - mrcvr 58 20 0.28 0.005
Other ges lmd/lmses to unfreeze in rcfg - mrcv 3 0 0.00 0.000
Other ges reconfiguration to start 2 0 0.04 0.019
Other ges2 LMON to wake up LMD - mrcvr 306 11 0.28 0.001
Other ges2 LMON to wake up lms - mrcvr 2 11 7 0.16 0.015
Other global enqueue expand wait 723 674 7.55 0.010
Other instance state change 2 0 0.00 0.000
Other jobq slave TJ process wait 5 5 0.05 0.011
Other kjbdrmcvtq lmon drm quiesce: ping comple 1713 89 5.65 0.003
Other kjctssqmg: quick message send wait 10 10 0.00 0.001
Other kksfbc child completion 174045 172703 8706.57 0.050
Other kkshgnc reloop 20 20 0.23 0.012
Other ksxr poll remote instances 2967968 2160571 25.55 0.000
Other latch free 733061 206 23243.72 0.032
Other latch: KCL gc element parent latch 7158 0 18.13 0.003
Other latch: cache buffer handles 44 0 0.17 0.004
Other latch: cache buffers lru chain 46512 0 1635.30 0.035
Other latch: checkpoint queue latch 538 0 0.72 0.001
Other latch: enqueue hash chains 99073 0 135.52 0.001
Other latch: gcs resource hash 5326 0 29.05 0.006
Other latch: ges resource hash list 441302 0 549.17 0.001
Other latch: messages 806 0 0.57 0.001
Other latch: object queue header heap 453 0 4.27 0.009
Other latch: object queue header operation 34496 0 2450.62 0.071
Other latch: parallel query alloc buffer 5 0 0.03 0.006
Other latch: redo allocation 23226 0 112.77 0.005
Other latch: session allocation 879553 0 4557.34 0.005
Other latch: undo global data 315096 0 1359.99 0.004
Other lock deadlock retry 88 88 0.01 0.000
Other lock escalate retry 1382 1106 1.07 0.001
Other log switch/archive 30 21 231.96 7.732
Other name-service call wait 1185 4 83.13 0.070
Other process terminate 11 11 0.55 0.050
Other rdbms ipc reply 258168 94 314.77 0.001
Other recovery area: computing applied logs 13 0 0.00 0.000
Other recovery area: computing backed up files 13 0 0.04 0.003
Other recovery area: computing dropped files 13 0 0.04 0.003
Other recovery area: computing obsolete files 13 0 3.39 0.261
Other reliable message 438424 434 687.95 0.002
Other rfi_insv_start 1 0 0.04 0.039
Other rfi_nsv_start 8 6 6.79 0.849
Other rfm_dmon_timeout_op 50 35 37.57 0.752
Other rfrdb_dbop 16 15 14.85 0.928
Other rfrm_nonzero_sub_count 128 126 124.10 0.970
Other rfrm_zero_sub_count 1 0 0.08 0.080
Other wait for a undo record 59636 27517 3131.11 0.053
Other wait for scn ack 392489 211 858.68 0.002
Other wait for stopper event to be increased 787 641 68.36 0.087
Other wait for sync ack 1 0 0.03 0.025
Other wait for tmc2 to complete 1 1 0.03 0.029
Other wait for votes 875 875 25.81 0.030
Other wait list latch free 12340 0 137.49 0.011
Idle DIAG idle wait 5059712 13 990648.73 0.196
Idle LNS ASYNC end of log 176407365 176401200 1912840.32 0.011
Idle PL/SQL lock timer 51215 50592 98900.69 1.931
Idle PX Deq Credit: need buffer 1039 4 8.30 0.008
Idle PX Deq: Execute Reply 314155 93473 3979.93 0.013
Idle PX Deq: Execution Msg 661366 44727 3629.52 0.006
Idle PX Deq: Join ACK 369122 127340 933.83 0.003
Idle PX Deq: Msg Fragment 249761 33845 124.15 0.001
Idle PX Deq: Par Recov Change Vector 22443 0 11.09 0.001
Idle PX Deq: Par Recov Execute 12917 0 37.99 0.003
Idle PX Deq: Par Recov Reply 73 0 2.38 0.033
Idle PX Deq: Parse Reply 328671 111763 165.84 0.001
Idle PX Deq: Txn Recovery Reply 1088 1 65.22 0.060
Idle PX Deq: Txn Recovery Start 28644 5945 28625.66 0.999
Idle PX Idle Wait 915791 752755 1965224.50 2.146
Idle SGA: MMAN sleep for component shrink 229 174 1.93 0.008
Idle SQL*Net message from client 904882886 0 135384663.24 0.150
Idle Streams AQ: RAC qmn coordinator idle wai 72626 72626 0.45 0.000
Idle Streams AQ: qmn coordinator idle wait 72615 36363 986066.06 13.579
Idle Streams AQ: qmn slave idle wait 37482 378 1011681.13 26.991
Idle Streams AQ: waiting for msgs in the q 206892 202303 990140.61 4.786
Idle Streams AQ: waiting for time mgmnt cleanup 31579 21726 966652.17 30.611
Idle class slave wait 885 0 0.64 0.001
Idle gcs remote message 176491254 171147733 3955264.04 0.022
Idle ges remote message 36667679 27429845 989476.61 0.027
Idle jobq slave wait 944664 534815 2346872.85 2.484
Idle pmon timer 432493 431676 989984.10 2.289
Idle rdbms ipc message 29054052 16226610 18461405.47 0.635
Idle smon timer 1883469 2 986578.18 0.524
Idle wait for unread message on broadcast cha 74283 56 417.72 0.006


[an error occurred while processing this directive]