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

Running SQL Statements

SQL ID Child # Plan Hash Schema SID Serial State Waiting Event SQL Text Outline Category
d6hqsqt4u8pab 7 1235506507 SXREPORTS_UXR 483 64658 WAITED SHORT TIME SQL*Net message from client SELECT ID ,TSTAMP_DT ,SLOT_ID FROM (SE
bdrpba43hz2q0 1 118459072 SXREPORTS_UXR 272 6158 WAITED SHORT TIME latch: cache buffers chains SELECT MAX (S.ID) FROM MAIN_REPORTS_LO
7v2ph8k7dthmu 0 2396832378 SXREPORTS 172 4710 WAITED SHORT TIME SQL*Net message from client DELETE GOB_REPORT_FILL_DT WHERE TSTAMP
bx1h88d1v56ar 3 1135778135 UXREPORTS_UXR 663 42532 WAITING db file sequential read INSERT INTO CLSD_BY_ACCT ( TSTAMP_ID ,
d6hqsqt4u8pab 7 1235506507 SXREPORTS_UXR 146 39967 WAITING db file sequential read SELECT ID ,TSTAMP_DT ,SLOT_ID FROM (SE
d6hqsqt4u8pab 7 1235506507 SXREPORTS_UXR 761 38279 WAITING db file sequential read SELECT ID ,TSTAMP_DT ,SLOT_ID FROM (SE
d6hqsqt4u8pab 7 1235506507 SXREPORTS_UXR 363 25108 WAITING db file sequential read SELECT ID ,TSTAMP_DT ,SLOT_ID FROM (SE
5jrqgd3u19b2t 0 4094995545 EMLIGHT 359 49802 WAITED SHORT TIME gc cr request SELECT S.SID ,S.SERIAL# ,S.LOGON_TIME ,N
78r5xad4ndqbs 1 1229379960 UXREPORTS_UXR 1430 25331 WAITED SHORT TIME SQL*Net message from client INSERT INTO EE_BALANCE_LOAD (SLOT_ID, SN
4mcsrbcb6qdpj 0 376125105 UXREPORTS 482 57972 WAITED SHORT TIME control file sequential read WITH START_DATE AS ( SELECT MIN(S.ACTIVE


[an error occurred while processing this directive]