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

Active Sessions

SID Serial# Status Server Schema Name SQL ID Event Seconds OS User Machine Program Service Name
153 31960 ACTIVE DEDICATED SYS jobq slave wait 78921.00 oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (J003) SYS$USERS
172 4710 ACTIVE DEDICATED SXREPORTS_UXR ON CPU 0.01 uxt2reports mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) rdemo16b
272 6158 ACTIVE DEDICATED SXREPORTS_UXR 18r2dv67pm6m2 ON CPU 0.01 uxt2reports mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) rdemo16b
373 21287 ACTIVE DEDICATED EMLIGHT b3skjamsxy7w2 ON CPU 0.01 oracle jrepdb01.obzora.prv httpd@jrepdb01.obzora.prv (TNS V1-V3) SYS$USERS
475 7352 ACTIVE DEDICATED UXREPORTS_WWW c4bt86udhj1nh db file sequential read 0.00 uxpa2 cust116.obzora.prv java@cust116.obzora.prv (TNS V1-V3) rdemo16a
483 64658 ACTIVE DEDICATED SXREPORTS_UXR ON CPU 0.01 uxt2reports mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) rdemo16b
614 43864 ACTIVE DEDICATED SYS jobq slave wait 1285.00 oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (J000) SYS$USERS
616 2304 ACTIVE DEDICATED SXREPORTS_UXR ON CPU 0.01 uxt2reports mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) rdemo16b
755 6889 ACTIVE DEDICATED SXREPORTS_UXR ON CPU 0.01 uxt2reports mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) rdemo16b
1006 23177 ACTIVE DEDICATED SYS ON CPU 28.99 oracle rrac16b.obzora.prv rman@rrac16b.obzora.prv (TNS V1-V3) SYS$USERS
1537 8988 ACTIVE DEDICATED UXREPORTS_WWW c4bt86udhj1nh read by other session 0.00 uxpa2 cust116.obzora.prv java@cust116.obzora.prv (TNS V1-V3) rdemo16a
1630 34718 ACTIVE DEDICATED d6hqsqt4u8pab ON CPU 0.00 uxt2reports mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) rdemo16b
2132 1184 ACTIVE DEDICATED DBSNMP Streams AQ: waiting for messages in the queue 4.00 oagent rrac16b.obzora.prv emagent@rrac16b.obzora.prv (TNS V1-V3) SYS$USERS


[an error occurred while processing this directive]