| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| DEMO | 3430975138 | DEMO3 | 3 | 26-Jun-09 00:06 | 11.1.0.7.0 | YES |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 916 | 27-Jun-09 17:53:39 | 41 | 1.3 |
| End Snap: | 917 | 27-Jun-09 17:56:00 | 41 | 1.4 |
| Elapsed: | 2.34 (mins) | |||
| DB Time: | 5.40 (mins) |
| SQL Id | Elapsed Time (ms) | Module | Action | SQL Text |
|---|---|---|---|---|
| 7b1a4ngy9q7kc | 311,175 | SQL*Plus | select /* eight */ /*+ parallel (t1, 16) parallel (t2, 16) */ min(t... |
| # | Plan Hash Value | Total Elapsed Time(ms) | Executions | 1st Capture Snap ID | Last Capture Snap ID |
|---|---|---|---|---|---|
| 1 | 2586167546 | 311,175 | 1 | 917 | 917 |
| Stat Name | Statement Total | Per Execution | % Snap Total |
|---|---|---|---|
| Elapsed Time (ms) | 311,175 | 311,175.31 | 96.01 |
| CPU Time (ms) | 194,842 | 194,842.38 | 98.81 |
| Executions | 1 | ||
| Buffer Gets | 971,917 | 971,917.00 | 98.34 |
| Disk Reads | 1,561,768 | 1,561,768.00 | 100.00 |
| Parse Calls | 5 | 5.00 | 0.47 |
| Rows | 1 | 1.00 | |
| User I/O Wait Time (ms) | 113,267 | ||
| Cluster Wait Time (ms) | 0 | ||
| Application Wait Time (ms) | 0 | ||
| Concurrency Wait Time (ms) | 0 | ||
| 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 |