| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| DEMO | 3430975138 | DEMO4 | 4 | 26-Jun-09 06:06 | 11.1.0.7.0 | YES |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 914 | 27-Jun-09 17:34:13 | 44 | 1.6 |
| End Snap: | 915 | 27-Jun-09 17:37:21 | 47 | 1.5 |
| Elapsed: | 3.14 (mins) | |||
| DB Time: | 12.05 (mins) |
| SQL Id | Elapsed Time (ms) | Module | Action | SQL Text |
|---|---|---|---|---|
| dgyay259941s4 | 696,196 | SQL*Plus | select /* four */ /*+ 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 | 696,196 | 1 | 915 | 915 |
| Stat Name | Statement Total | Per Execution | % Snap Total |
|---|---|---|---|
| Elapsed Time (ms) | 696,196 | 696,195.77 | 96.33 |
| CPU Time (ms) | 373,943 | 373,943.15 | 98.80 |
| Executions | 1 | ||
| Buffer Gets | 1,920,079 | 1,920,079.00 | 97.49 |
| Disk Reads | 3,074,972 | 3,074,972.00 | 98.48 |
| Parse Calls | 9 | 9.00 | 1.22 |
| Rows | 1 | 1.00 | |
| User I/O Wait Time (ms) | 242,513 | ||
| Cluster Wait Time (ms) | 65,496 | ||
| Application Wait Time (ms) | 1 | ||
| Concurrency Wait Time (ms) | 14,709 | ||
| 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 |