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

SQL Details: d6hqsqt4u8pab

           


There are 4 plans found for this SQL statement



Feb 16, 2012 12:03:42 pm, Interval: 10 minutes
SQL ID: d6hqsqt4u8pab Plan Hash: 3421390755
Username Session Child# Plan Hash Waits/Minute %% Program SQL Text
UXREPORTS 616 7 3421390755 10 15 java@tw16.obzora.prv (TNS) SELECT ID ,TSTAMP_SNAP ,SLOT_ID FROM (SE
UXREPORTS 755 7 3421390755 9 14 java@tw16.obzora.prv (TNS) SELECT ID ,TSTAMP_SNAP ,SLOT_ID FROM (SE
UXREPORTS 272 7 3421390755 8 13 java@tw16.obzora.prv (TNS) SELECT ID ,TSTAMP_SNAP ,SLOT_ID FROM (SE
UXREPORTS 1460 7 3421390755 8 13 java@tw16.obzora.prv (TNS) SELECT ID ,TSTAMP_SNAP ,SLOT_ID FROM (SE
UXREPORTS 483 7 3421390755 8 13 java@tw16.obzora.prv (TNS) SELECT ID ,TSTAMP_SNAP ,SLOT_ID FROM (SE
UXREPORTS 172 7 3421390755 8 11 java@tw16.obzora.prv (TNS) SELECT ID ,TSTAMP_SNAP ,SLOT_ID FROM (SE
UXREPORTS 1630 7 3421390755 8 11 java@tw16.obzora.prv (TNS) SELECT ID ,TSTAMP_SNAP ,SLOT_ID FROM (SE
UXREPORTS 1255 7 3421390755 6 9 java@tw16.obzora.prv (TNS) SELECT ID ,TSTAMP_SNAP ,SLOT_ID FROM (SE
Total Waits 65


[an error occurred while processing this directive]