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

Background Sessions

SID Serial# Status Server Schema Name OS User Machine Program SQL ID Event Seconds Service Name
235 13883 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (RSM0) rdbms ipc message 18.00 SYS$BACKGROUND
1445 63831 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (q001) Streams AQ: qmn slave idle wait 275.00 SYS$BACKGROUND
1476 3415 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (m001) db file sequential read 1.00 SYS$BACKGROUND
2137 20 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (q000) 4gd6b1r53yt88 Streams AQ: waiting for time management or cleanup tasks 19.00 SYS$BACKGROUND
2139 3 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (QMNC) Streams AQ: qmn coordinator idle wait 8.00 SYS$BACKGROUND
2168 3 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LNS1) LNS ASYNC end of log 0.00 SYS$BACKGROUND
2169 3 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LNS2) LNS ASYNC end of log 0.00 SYS$BACKGROUND
2173 3 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (INSV) rdbms ipc message 15.00 SYS$BACKGROUND
2174 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (ARC1) rdbms ipc message 38.00 SYS$BACKGROUND
2175 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (ARC0) rdbms ipc message 26.00 SYS$BACKGROUND
2176 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (NSV2) rdbms ipc message 18.00 SYS$BACKGROUND
2177 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (NSV1) rdbms ipc message 18.00 SYS$BACKGROUND
2181 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (DMON) rdbms ipc message 3.00 SYS$BACKGROUND
2182 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LCK0) rdbms ipc message 1.00 SYS$BACKGROUND
2183 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (MMNL) rdbms ipc message 53.00 SYS$BACKGROUND
2184 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (MMON) 4gd6b1r53yt88 rdbms ipc message 3.00 SYS$BACKGROUND
2185 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (CJQ0) rdbms ipc message 66.00 SYS$BACKGROUND
2186 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (RECO) rdbms ipc message 69.00 SYS$BACKGROUND
2187 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (SMON) smon timer 5.00 SYS$BACKGROUND
2188 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (CKPT) rdbms ipc message 1.00 SYS$BACKGROUND
2190 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LGWR) rdbms ipc message 0.00 SYS$BACKGROUND
2192 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (DBW1) rdbms ipc message 1.00 SYS$BACKGROUND
2194 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (DBW0) rdbms ipc message 3.00 SYS$BACKGROUND
2196 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (MMAN) rdbms ipc message 106710.00 SYS$BACKGROUND
2197 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LMS3) gcs remote message 4.00 SYS$BACKGROUND
2198 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LMS2) gcs remote message 3.00 SYS$BACKGROUND
2199 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LMS1) gcs remote message 5.00 SYS$BACKGROUND
2200 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LMS0) gcs remote message 15.00 SYS$BACKGROUND
2201 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LMD0) ges remote message 2.00 SYS$BACKGROUND
2202 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (LMON) rdbms ipc message 1.00 SYS$BACKGROUND
2203 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (PSP0) rdbms ipc message 3.00 SYS$BACKGROUND
2204 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (DIAG) DIAG idle wait 12625.00 SYS$BACKGROUND
2205 1 ACTIVE DEDICATED SYS oracle rrac16b.obzora.prv oracle@rrac16b.obzora.prv (PMON) pmon timer 12526.00 SYS$BACKGROUND


[an error occurred while processing this directive]