| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| DEMO | 3430975138 | DEMO1 | 1 | 26-Jun-09 00:06 | 11.1.0.7.0 | YES |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 910 | 27-Jun-09 17:16:56 | 45 | 1.6 |
| End Snap: | 911 | 27-Jun-09 17:21:53 | 56 | 1.3 |
| Elapsed: | 4.96 (mins) | |||
| DB Time: | 52.43 (mins) |
| SQL Id | Elapsed Time (ms) | Module | Action | SQL Text |
|---|---|---|---|---|
| a6r9zzu06tudh | 3,042,957 | SQL*Plus | select /* one */ /*+ parallel (t1, 16) parallel (t2, 16) */ min(t1.... |
| # | Plan Hash Value | Total Elapsed Time(ms) | Executions | 1st Capture Snap ID | Last Capture Snap ID |
|---|---|---|---|---|---|
| 1 | 2586167546 | 3,042,957 | 1 | 911 | 911 |
| Stat Name | Statement Total | Per Execution | % Snap Total |
|---|---|---|---|
| Elapsed Time (ms) | 3,042,957 | 3,042,956.74 | 96.73 |
| CPU Time (ms) | 1,415,542 | 1,415,541.80 | 98.51 |
| Executions | 1 | ||
| Buffer Gets | 7,630,868 | 7,630,868.00 | 99.43 |
| Disk Reads | 13,409,423 | 13,409,423.00 | 99.92 |
| Parse Calls | 33 | 33.00 | 2.04 |
| Rows | 1 | 1.00 | |
| User I/O Wait Time (ms) | 1,421,957 | ||
| Cluster Wait Time (ms) | 100 | ||
| Application Wait Time (ms) | 1 | ||
| Concurrency Wait Time (ms) | 49,128 | ||
| Invalidations | 0 | ||
| Version Count | 1 | ||
| Sharable Mem(KB) | 34 |
| Id | Operation | Name | Rows | Bytes | TempSpc | Cost (%CPU) | Time | Pstart | Pstop | TQ | IN-OUT | PQ Distrib |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | SELECT STATEMENT | 302K(100) | ||||||||||
| 1 | SORT AGGREGATE | 1 | 88 | |||||||||
| 2 | PX COORDINATOR | |||||||||||
| 3 | PX SEND QC (RANDOM) | :TQ10002 | 1 | 88 | Q1,02 | P->S | QC (RAND) | |||||
| 4 | SORT AGGREGATE | 1 | 88 | Q1,02 | PCWP | |||||||
| 5 | HASH JOIN | 468M | 38G | 1395M | 302K (1) | 01:00:26 | Q1,02 | PCWP | ||||
| 6 | PX RECEIVE | 468M | 16G | 73380 (1) | 00:14:41 | Q1,02 | PCWP | |||||
| 7 | PX SEND HASH | :TQ10000 | 468M | 16G | 73380 (1) | 00:14:41 | Q1,00 | P->P | HASH | |||
| 8 | PX BLOCK ITERATOR | 468M | 16G | 73380 (1) | 00:14:41 | 1 | 31 | Q1,00 | PCWC | |||
| 9 | TABLE ACCESS STORAGE FULL | DWB_RTL_TRX | 468M | 16G | 73380 (1) | 00:14:41 | 1 | 31 | Q1,00 | PCWP | ||
| 10 | PX RECEIVE | 468M | 21G | 73349 (1) | 00:14:41 | Q1,02 | PCWP | |||||
| 11 | PX SEND HASH | :TQ10001 | 468M | 21G | 73349 (1) | 00:14:41 | Q1,01 | P->P | HASH | |||
| 12 | PX BLOCK ITERATOR | 468M | 21G | 73349 (1) | 00:14:41 | 1 | 31 | Q1,01 | PCWC | |||
| 13 | TABLE ACCESS STORAGE FULL | DWB_RTL_TRX | 468M | 21G | 73349 (1) | 00:14:41 | 1 | 31 | Q1,01 | PCWP |