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 SQL Statements



<-prev next->     Total SQL Statements:
## SQL ID Versions SQL Text Gets/Exec Reads/Exec CPU/Exec, ms Disk Reads Buffer Gets Rows
Processed
Fetches Executions Total
Parses
Hard
Parses
Avg Hard
Parse Time, ms
CPU Time, ms Elapsed Time, ms Concurrency
Wait Time, ms
User I/O
Wait Time, ms
Sharable
Memory, KB
1 4kzcxvpcq2y0m 1 select min(minbkt),maxbkt,substrb(dump(m 78333768 1228508 296421 1228508 78333768 254 1 1 1 1 2 296421 3048752 2404 2728553 3.12
2 f2u27f76tm191 1 select * from global_reports_log order b 18356010 248896 75487 1742272 128492068 200 7 7 7 4 957 528407 19682040 20437 18138147 14.98
3 f310h22vvb35y 2 WITH PLAIN AS (SELECT ACCT_ID 817000 16652 6222 765973 37581977 1620 224 46 46 13 1184 286233 3638577 35058 3195216 26.13
4 c4bt86udhj1nh 2 WITH PLAIN AS ( SELECT D.ACCT_ID 506296 6676 3989 373877 28352587 1102 176 56 56 2 5299 223359 2001045 908 1693575 10.42
5 1zxwmgnhk7z44 1 WITH PLAIN AS (SELECT ACCT_ID 231977 4767 2717 38138 1855812 6762 687 8 8 2 922 21734 174234 4 148098 7.30
6 18kpaff7rp55d 2 SELECT DECODE(GROUPING(DT.MERCHANT_ACCT_ 187753 2129 1125 1986371 175173357 1934 1641 933 933 9 1393 1049574 7794805 3316 6539728 116.75
7 7b3sgk7sm4hj1 1 SELECT DECODE(GROUPING_ID(RN, OFFICE_ID, 139383 522 1331 8349 2230132 48254 4849 16 16 1 2748 21290 72127 46 47160 7.66
8 dwm6gw0y734st 1 select sum(trd_sm), sum(bnk_sm) from rcl 134924 34352 17077 34352 134924 1 1 1 2 1 339 17077 38518 22 21309 7.30
9 5wdr5xjtkc9z7 1 SELECT MAX(BEG_BALANCE) BEG_BALANCE 113825 1414 606 21209 1707368 4863 507 15 15 1 159 9087 53994 10 44260 6.26
10 fpqsx33abra5c 3 SELECT OFFER_ID ,ACCT_ID ,Min( 101933 1559 751 283667 18551787 134137 13672 182 182 4 977 136711 1431041 649 1239600 19.82
11 0b4u9bpgx1m2q 1 SELECT * FROM rcl_outages where PAIR = : 94420 5423 12616 54229 944199 4254 22 10 20 1 425 126164 207049 11 79715 7.30
12 6xuuz3307j680 1 SELECT sl_id ,MAX(period_end) 85664 13 363 26 171328 116 2 2 2 1 2872 727 3590 10 2861 4.16
13 44t3swhpq0ff2 1 SELECT sl_id ,MAX(period_end) 85406 6 421 8975 128195078 87058 1501 1501 1501 5 2339 631760 733840 6573 60400 4.16
14 950xkjkgqsq09 1 SELECT DECODE(GROUPING(MERCHANT.OFFICE_I 70042 1385 765 2896824 146527336 38290 6406 2092 2092 25 793 1600390 12118928 128792 10336835 27.20
15 a707ym9xgcrb3 2 WITH GAAP AS ( SELECT GAAP.REPORT 53856 1918 852 653914 18365057 931933 93665 341 341 5 4205 290410 3973626 136304 3268225 22.98
16 ad9g5hr0dc94r 1 SELECT d. * ,ROWID FROM global_r 37541 0 239 1 4767765 5737 127 127 127 1 128 30354 30546 0 123 4.16
17 c9kf46z5grcb2 1 SELECT d. * ,ROWID FROM global_r 36110 0 274 19 167877081 48601 4687 4649 4649 1 4 1273390 1274480 29 33 4.16
18 866t2b6pkkx19 1 SELECT d. * ,ROWID FROM global_r 35652 0 227 43 618628250 182195 17379 17352 17352 1 1123 3936608 3943213 141 1528 31.87
19 gv0d1wz9vcjnx 1 WITH ACCT_IDS AS (SELECT T.*, ROWNUM RN 30051 293 211 446191 45797954 3301531 332598 1524 1524 4 40 321868 1097271 42321 702651 7.30
20 dj2hvak5qqvzu 1 SELECT DISTINCT OFFER_ID FROM GLOBA 30003 760 272 1158795 45725027 8028 2703 1524 1524 5 1279 414946 5780546 381 5296057 61.69


[an error occurred while processing this directive]