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 10 Sessions (last minutes)

Activity (%) SID %% Username Program
1006 8 SYS rman@rrac16b.obzora.prv (TNS V1-V3)
616 6 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1255 6 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
272 6 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1460 6 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
483 6 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1630 6 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
755 6 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
475 6 UXREPORTS_WWW java@cust116.obzora.prv (TNS V1-V3)
172 6 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
 

 Legend


Session Wait Class Statistic

<-prev next->     Total Rows:
## SID User I/O System I/O Commit Concurrency Application Configuration Administrative Scheduler Cluster Network Other
1 1470 0.0% 0.0% 0.8% 0.8% 0.1% 0.0% 0.0% 0.1%
2 290 0.0% 0.0% 0.0% 0.1% 0.0% 0.0% 0.7% 0.0% 0.0%
3 2081 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
4 1733 0.0% 0.0% 0.4% 0.0% 0.0% 0.0% 0.0% 0.1% 0.0%
5 1966 0.0% 0.5% 0.0% 0.0% 0.0% 0.0% 0.1% 0.0%
6 1829 0.0% 0.3% 0.3% 0.0% 0.2% 0.0% 0.0% 0.1% 0.0%
7 774 0.0% 0.7% 0.0% 0.4% 0.0% 0.0% 0.1% 0.0%
8 475 0.0% 0.9% 0.5% 0.0% 0.8% 0.0% 0.0% 0.1% 0.0%
9 2019 0.0% 0.9% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
10 142 0.0% 0.0% 0.0% 0.0% 0.0% 0.8% 0.1% 0.0%
11 1537 0.0% 0.1% 0.5% 0.0% 0.0% 0.0% 0.0% 0.2% 0.0% 0.0%
12 2188 0.0% 0.1% 0.8% 0.0% 0.0% 0.0% 0.0% 0.3%
13 1630 0.0% 0.0% 0.0% 0.0% 0.0% 0.2%
14 1981 1.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.1% 0.0% 0.0%
15 1836 0.7% 0.0% 0.0% 0.3% 0.0% 0.0% 0.0% 0.0% 0.9% 0.0% 0.0%


[an error occurred while processing this directive]