更新时间:2021-11-24 00:01:26
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 |
. |
. |
|
|
|
. |
||||||
|