| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| DEMO | 3430975138 | DEMO2 | 2 | 26-Jun-09 00:06 | 11.1.0.7.0 | YES |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 912 | 27-Jun-09 17:26:05 | 48 | 3.2 |
| End Snap: | 913 | 27-Jun-09 17:30:07 | 54 | 2.8 |
| Elapsed: | 4.03 (mins) | |||
| DB Time: | 30.06 (mins) |
| SQL Id | Elapsed Time (ms) | Module | Action | SQL Text |
|---|---|---|---|---|
| 54patfpds4pp3 | 1,729,557 | SQL*Plus | select /* two */ /*+ 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 | 1,729,557 | 1 | 913 | 913 |
| Stat Name | Statement Total | Per Execution | % Snap Total |
|---|---|---|---|
| Elapsed Time (ms) | 1,729,557 | 1,729,557.20 | 95.90 |
| CPU Time (ms) | 1,064,743 | 1,064,743.14 | 97.95 |
| Executions | 1 | ||
| Buffer Gets | 3,619,830 | 3,619,830.00 | 98.11 |
| Disk Reads | 6,279,361 | 6,279,361.00 | 99.59 |
| Parse Calls | 16 | 16.00 | 1.21 |
| Rows | 1 | 1.00 | |
| User I/O Wait Time (ms) | 584,539 | ||
| Cluster Wait Time (ms) | 11 | ||
| Application Wait Time (ms) | 1 | ||
| Concurrency Wait Time (ms) | 25,938 | ||
| 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 |