| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| DEMO | 3430975138 | DEMO2 | 2 | 30-Jun-09 12:06 | 11.1.0.7.0 | YES |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 1043 | 02-Jul-09 12:57:16 | 42 | 1.4 |
| End Snap: | 1044 | 02-Jul-09 12:59:02 | 42 | 1.4 |
| Elapsed: | 1.76 (mins) | |||
| DB Time: | 11.34 (mins) |
| SQL Id | Elapsed Time (ms) | Module | Action | SQL Text |
|---|---|---|---|---|
| crqv3q3x9rtgt | 635,664 | SQL*Plus | select /* two */ /*+ parallel (t1, 16) parallel (t2, 16) */ ... |
| # | Plan Hash Value | Total Elapsed Time(ms) | Executions | 1st Capture Snap ID | Last Capture Snap ID |
|---|---|---|---|---|---|
| 1 | 1755470101 | 635,664 | 1 | 1044 | 1044 |
| Stat Name | Statement Total | Per Execution | % Snap Total |
|---|---|---|---|
| Elapsed Time (ms) | 635,664 | 635,663.52 | 93.47 |
| CPU Time (ms) | 554,640 | 554,639.68 | 95.32 |
| Executions | 1 | ||
| Buffer Gets | 2,711,331 | 2,711,331.00 | 93.86 |
| Disk Reads | 2,995,058 | 2,995,058.00 | 95.23 |
| Parse Calls | 9 | 9.00 | 1.82 |
| Rows | 1 | 1.00 | |
| User I/O Wait Time (ms) | 65,978 | ||
| Cluster Wait Time (ms) | 0 | ||
| Application Wait Time (ms) | 5 | ||
| Concurrency Wait Time (ms) | 1 | ||
| Invalidations | 0 | ||
| Version Count | 1 | ||
| Sharable Mem(KB) | 30 |
| 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) | :TQ10000 | 1 | 88 | Q1,00 | P->S | QC (RAND) | |||||
| 4 | SORT AGGREGATE | 1 | 88 | Q1,00 | PCWP | |||||||
| 5 | PX PARTITION HASH ALL | 470M | 38G | 302K (1) | 01:00:29 | 1 | 64 | Q1,00 | PCWC | |||
| 6 | HASH JOIN | 470M | 38G | 1395M | 302K (1) | 01:00:29 | Q1,00 | PCWP | ||||
| 7 | PX PARTITION RANGE ALL | 468M | 16G | 73512 (1) | 00:14:43 | 1 | 31 | Q1,00 | PCWC | |||
| 8 | TABLE ACCESS STORAGE FULL | DWB_RTL_TRX | 468M | 16G | 73512 (1) | 00:14:43 | 1 | 1984 | Q1,00 | PCWP | ||
| 9 | PX PARTITION RANGE ALL | 468M | 21G | 73481 (1) | 00:14:42 | 1 | 31 | Q1,00 | PCWC | |||
| 10 | TABLE ACCESS STORAGE FULL | DWB_RTL_TRX | 468M | 21G | 73481 (1) | 00:14:42 | 1 | 1984 | Q1,00 | PCWP |