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

Top 20 Sessions by Memory

Size in Kilobytes
SID UGA Max UGA PGA Max PGA Undo Redo Workarea Username Machine Program Logon Time
1376 46411 48337 57580 59692 10 30 0 DBSNMP prmon1.obzora.prv OMS 02/15/12 08:36:48pm
1723 9342 10092 11436 12076 0 0 0 UXREPORTS bt12.obzora.prv sqlplus@bt12.obzora.prv (TNS V1-V3) 02/14/12 11:34:27am
2137 9041 9588 9435 10459 1950 3816 0 SYS rrac16b.obzora.prv oracle@rrac16b.obzora.prv (q000) 02/05/12 07:19:31pm
2124 8206 8206 8748 8748 13 38 0 SYS rrac16b.obzora.prv racgimon@rrac16b.obzora.prv (TNS V1-V3) 02/05/12 07:19:33pm
2153 6543 13634 11052 17772 28 94 0 DIXI prmon1.obzora.prv OMS 02/14/12 11:30:10am
2187 6040 7061 11291 31195 21226 490351 0 SYS rrac16b.obzora.prv oracle@rrac16b.obzora.prv (SMON) 02/05/12 07:18:22pm
305 5675 8823 6572 9836 18 54 0 DBSNMP rrac16b.obzora.prv emagent@rrac16b.obzora.prv (TNS V1-V3) 02/15/12 08:09:00am
2132 5587 12160 6188 13164 530 1548 0 DBSNMP rrac16b.obzora.prv emagent@rrac16b.obzora.prv (TNS V1-V3) 02/05/12 07:22:19pm
2053 5081 6905 6956 29164 3857 9256 0 UXREPORTS USA\NYC-DEV-7860 plsqldev.exe 02/14/12 12:06:00am
1915 3734 7570 4204 9772 5 73 0 HXREPORTS_WWW cust144.obzora.prv java@cust144.obzora.prv (TNS V1-V3) 02/12/12 07:37:26pm
290 3733 5063 7916 12716 8871 23708 0 SXREPORTS bt12.obzora.prv sqlplus@bt12.obzora.prv (TNS V1-V3) 02/14/12 11:51:37pm
1829 2974 191399 3803 193179 61 1246 0 UXREPORTS_WWW cust116.obzora.prv java@cust116.obzora.prv (TNS V1-V3) 02/14/12 12:19:45am
1607 2932 2932 4268 4268 4 13 1 EMLIGHT jrepdb01.obzora.prv httpd@jrepdb01.obzora.prv (TNS V1-V3) 02/16/12 05:49:50pm
1364 2391 24289 2796 25836 3 19 1 UXREPORTS_WWW cust116.obzora.prv java@cust116.obzora.prv (TNS V1-V3) 02/14/12 11:41:04am
1733 2371 213070 3564 222060 3 823 0 UXREPORTS_WWW cust115.obzora.prv java@cust115.obzora.prv (TNS V1-V3) 02/14/12 12:18:37am
774 2215 196816 3035 206363 78 1477 0 UXREPORTS_WWW cust144.obzora.prv java@cust144.obzora.prv (TNS V1-V3) 02/15/12 02:00:28am
1880 2135 12472 6491 13147 26 416 0 UXREPORTS bt12.obzora.prv sqlplus@bt12.obzora.prv (TNS V1-V3) 02/14/12 06:44:39pm
622 1816 2419 2220 3564 1839 6080 0 UXREPORTS_UXR mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) 02/16/12 09:58:51am
2158 1816 1816 2412 2476 312435 844046 0 UXREPORTS_UXR mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) 02/16/12 05:00:16pm
1027 1816 1816 2412 2412 22557 67222 0 UXREPORTS_UXR mw16.obzora.prv java@mw16.obzora.prv (TNS V1-V3) 02/16/12 05:00:19pm



[an error occurred while processing this directive]