本文共 9327 字,大约阅读时间需要 31 分钟。
Id | Operation | Name | Estimated Rows | Cost | Active Period (678s) | Execs | Rows | Memory | Temp | IO Requests | CPU Activity | Wait Activity | Progress | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
. | 0 | SELECT STATEMENT | . | . | . | . | 1 | . | . | . | | . | . | . | |||||||||||
. | 1 | . SORT AGGREGATE | . | 1 | . |
| 1 | 0 | . | . | |
| | . | |||||||||||
-> | 2 | .. HASH JOIN | . | 10G | 305K |
| 1 | 4G | 7.3MB | . | |
| | . | |||||||||||
. | 3 | ... HASH JOIN | . | 76218 | 260K |
| 1 | 90960 | . | . | | . | . | . | |||||||||||
. | 4 | .... PARTITION RANGE ALL | . | 602K | 248K |
| 1 | 449K | . | . | | . | . | . | |||||||||||
. | 5 | ..... TABLE ACCESS FULL | BL1_RC_RATES | 602K | 248K |
| 11 | 449K | . | . |
|
|
|
| |||||||||||
. | 6 | .... TABLE ACCESS FULL | SUBSCRIBER | 1M | 8495 |
| 1 | 1M | . | . | | . | . | . | |||||||||||
-> | 7 | ... TABLE ACCESS FULL | CUSTOMER | 1M | 7441 |
| 1 | 464K | . | . | |
| |
| |||||||||||
. | 8 | . HASH UNIQUE | . | 1 | 469K | . | 1 | . | . | . | | . | . | . | |||||||||||
. | 9 | .. FILTER | . | . | . | . | 1 | . | . | . | | . | . | . | |||||||||||
. | 10 | ... PX COORDINATOR | . | . | . | . | 17 | . | . | . | | . |
Id | Operation | Name | Estimated Rows | Cost | Active Period (235s) | Execs | Rows | Memory | Temp | IO Requests | CPU Activity | Wait Activity | Progress | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
. | 0 | SELECT STATEMENT | . | . | . | . | . | . | . | . | | . | . | . | ||||||
. | 1 | . SORT AGGREGATE | . | 1 | . | . | . | . | . | . | | . | . | . | ||||||
. | 2 | .. PARTITION RANGE ALL | . | 1 | 3 | . | . | . | . | . | | . | . | . | ||||||
. | 3 | ... TABLE ACCESS BY LOCAL INDEX ROWID | BL1_RC_RATES | 1 | 3 | . | . | . | . | . | | . | . | . | ||||||
. | 4 | .... INDEX RANGE SCAN | BL1_RC_RATES_3IX | 8 | 2 | . | . | . | . | . | | . | . | . | ||||||
. | 5 | . HASH UNIQUE | . | 1 | 39T | . | 1 | . | . | . | | . | . | . | ||||||
-> | 6 | .. FILTER | . | . | . |
| 1 | 0 | . | . | |
| | . | ||||||
-> | 7 | ... PX COORDINATOR | . | . | . |
| 9 | 260M | . | . | |
| | . | ||||||
-> | 8 | .... PX SEND QC (RANDOM) | :TQ10006 | 20T | 30G |
| 8 | 260M | . | . | |
| | . | ||||||
-> | 9 | ..... NESTED LOOPS | . | 20T | 30G |
| 8 | 260M | . | . | | . | . | . | ||||||
-> | 10 | ...... HASH JOIN | . | 30G | 96M |
| 8 | 89181 | 23.4MB | . | | . | . | . | ||||||
. | 11 | ....... BUFFER SORT | . | . | . |
| 8 | 152K | . | . | | . | . | . | ||||||
. | 12 | ........ PX RECEIVE | . | 16895 | 40 |
| 8 | 152K | . | . | | . | . | . | ||||||
. | 13 | ......... PX SEND BROADCAST | :TQ10000 | 16895 | 40 |
| 1 | 152K | . | . | | . | . | . | ||||||
. | 14 | .......... MAT_VIEW ACCESS FULL | CSM_DEALER | 16895 | 40 |
| 1 | 18958 | . | . | | . | . | . | ||||||
-> | 15 | ....... NESTED LOOPS | . | 31G | 96M |
| 8 | 89181 | . | . | | . | . | . | ||||||
-> | 16 | ........ HASH JOIN | . | 46M | 3M |
| 8 | 26 | 498.2MB | . | |
| | . | ||||||
. | 17 | ......... BUFFER SORT | . | . | . |
| 8 | 10M | . | . | |
| | . | ||||||
. | 18 | .......... PX RECEIVE | . | 944K | 5947 |
| 8 | 10M | . | . | |
| | . | ||||||
. | 19 | ........... PX SEND BROADCAST | :TQ10001 | 944K | 5947 |
| 1 | 10M | . | . | | . | . | . | ||||||
. | 20 | ............ TABLE ACCESS FULL | ACCOUNT | 944K | 5947 |
| 1 | 1M | . | . |
|
|
| . | ||||||
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23718752/viewspace-1217816/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23718752/viewspace-1217816/