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 15 Sessions

Activity (%) SID %% Username Program
719 8.02 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1597 8.02 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1675 8.02 UXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
663 8.02 UXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1006 7.84 SYS rman@rrac16b.obzora.prv (TNS V1-V3)
272 5.83 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
483 5.79 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
755 5.77 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1630 5.75 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1460 5.73 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
616 5.65 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
172 5.64 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
1255 5.61 SXREPORTS_UXR java@mw16.obzora.prv (TNS V1-V3)
2174 2.31 SYS oracle@rrac16b.obzora.prv (ARC1)
2169 1.70 SYS oracle@rrac16b.obzora.prv (LNS2)

Top Events

Legend

Top 15 PL/SQL

Activity (%) %% PL/SQL Entry Subprogram PL/SQL Subprogram
52.51 SXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID
16.79 UXREPORTS.MAIN_REPORTS_UTILS.TSTAMP_LOG UXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID
16.31 SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
3.17 SXREPORTS.MAIN_REPORTS_UTILS.CLEAN_TSTAMP_DATA
2.26 UXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID UXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID
1.87 SXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID SXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID
1.17 EMLIGHT.VP$.GO
1.09 UXREPORTS.MAIN_REPORTS_UPD.RCL_TRDO
0.89 UXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID
0.72 UXREPORTS.MAIN_REPORTS_UPD.RCL_EXEO
0.58 EMLIGHT.VP$X.UNIT_164703 EMLIGHT.VP$.GO
0.56 UXREPORTS.MAIN_REPORTS_UPD.RCL_BNKO
0.45 SXREPORTS.MAIN_REPORTS_UTILS.CLEAN_TSTAMP_DATA SXREPORTS.MAIN_REPORTS_UTILS.CLEAN_TSTAMP_DATA
0.19 SXREPORTS.MAIN_REPORTS_UTILS.TSTAMP_LOG SXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID
0.17 SXREPORTS.MAIN_REPORTS_UTILS.CURR_TSTAMP_TIME SXREPORTS.MAIN_REPORTS_UTILS.GET_TSTAMP_ID

Top 15 SQL

Activity (%) %% SQL ID Child # SQL Type Username
56.38 d6hqsqt4u8pab 7 SELECT SXREPORTS_UXR
19.05 a7bfn9gf4j4td 1 UPDATE UXREPORTS_UXR
3.40 0m9v109wrcpfn 1 PL/SQL EXECUTE SXREPORTS_UXR
2.80 4mcsrbcb6qdpj 0 SELECT UXREPORTS_UXR
1.43 18r2dv67pm6m2 0 PL/SQL EXECUTE SXREPORTS_UXR
1.18 azwn5htawpj41 1 INSERT UXREPORTS_UXR
1.14 4k6z7du00hd4n 0 PL/SQL EXECUTE EMLIGHT
1.11 950xkjkgqsq09 0 SELECT UXREPORTS_WWW
1.02 a7bfn9gf4j4td 0 UPDATE SXREPORTS_UXR
0.99 866t2b6pkkx19 0 SELECT UXREPORTS
0.92 bdrpba43hz2q0 3 SELECT SXREPORTS_UXR
0.73 477rtx9zbd72u 3 SELECT SXREPORTS_UXR
0.73 26bznut7krph1 0 SELECT EMLIGHT
0.67 f5c2cun20afkv 1 SELECT UXREPORTS_RO
0.64 a6a4gn2c8vq77 0 INSERT UXREPORTS_UXR


[an error occurred while processing this directive]