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

Automatic Undo Management

Undo Retention Settings

Undo Management Auto? AUTO
Undo Retention (minutes)300
Undo Retention NOGUARANTEE
Undo Tablespace UNDOTBS02
       

Undo Tablespace

Tablespace Name UNDOTBS02
Number of Files 10
Auto-Extensible NO
Size 20000 MB
User Size 19999 MB
Size Max 0 MB

Longest Queries

SQL ID Exec Count Seconds/Exec Query Length, sec. SQL Text
d6hqsqt4u8pab 483 2675.45 1292243 SELECT ID ,TSTAMP_DT ,SLOT_ID FROM (SELECT ID, TSTAMP_DT
950xkjkgqsq09 51 3230.65 164763 SELECT DECODE(GROUPING(MERCHANT.OFFICE_ID), :"SYS_B_0", :"SY
7v2ph8k7dthmu 69 1595.38 110081 DELETE GOB_REPORT_FILL_DT WHERE TSTAMP_ID=:"SYS_B_0" AND S
f2u27f76tm191 13 4519.23 58750 select * from global_reports_log order by global_dt desc
18kpaff7rp55d 22 2496.55 54924 SELECT DECODE(GROUPING(DT.MERCHANT_ACCT_ID), :"SYS_B_0", :"S
f5c2cun20afkv 27 613.04 16552 select ccy, amt from ee_balance_alarm order by amt desc
81nv5aw7zhm11 104 154.38 16056 UPDATE CLSD_BY_ACCT G SET G.GROSS_PL = :B8 ,G.COMM = :B7 ,G.
fh457b8u5tpag 7 1202.86 8420 SELECT a.r||:"SYS_B_00"||decode(b.SL_NAME,NULL,:"SYS_B_01",:
dj2hvak5qqvzu 13 584.31 7596 SELECT DISTINCT OFFER_ID FROM GLOBAL_MERCH_ACTIVITY_PNL



[an error occurred while processing this directive]