Skip to content

Instantly share code, notes, and snippets.

@databasetech0073

databasetech0073/gist:d123af1aa4c0c4a0716725103c3c57c9 Secret

Created November 10, 2022 19:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save databasetech0073/d123af1aa4c0c4a0716725103c3c57c9 to your computer and use it in GitHub Desktop.
Save databasetech0073/d123af1aa4c0c4a0716725103c3c57c9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
********************* Execution which was running fine in 19.11 version **********************
Global Information
------------------------------
Status : DONE
Instance ID : 2
SQL Execution ID : 33554457
Execution Started : 10/04/2022 06:50:25
First Refresh Time : 10/04/2022 06:50:35
Last Refresh Time : 10/04/2022 07:50:45
Duration : 3620s
PLSQL Entry Ids (Object/Subprogram) : 25723986,1
PLSQL Current Ids (Object/Subprogram) : 25723986,1
Binds
========================================================================================================================
| Name | Position | Type | Value |
========================================================================================================================
| :B1 | 1 | DATE | 02/10/2018 00:00:00 |
========================================================================================================================
Global Stats
====================================================================================================================================
| Elapsed | Cpu | IO | Application | Concurrency | Cluster | Other | Buffer | Read | Read | Write | Write | Cell |
| Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Gets | Reqs | Bytes | Reqs | Bytes | Offload |
====================================================================================================================================
| 17561 | 13564 | 3968 | 0.01 | 8.31 | 16 | 4.18 | 298M | 1M | 662GB | 289K | 50GB | 71.43% |
====================================================================================================================================
Parallel Execution Details (DOP=16 , Servers Allocated=32)
=================================================================================================================================================================================================================
| Name | Type | Server# | Elapsed | Cpu | IO | Application | Concurrency | Cluster | Other | Buffer | Read | Read | Write | Write | Cell | Wait Events |
| | | | Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Gets | Reqs | Bytes | Reqs | Bytes | Offload | (sample #) |
=================================================================================================================================================================================================================
| PX Coordinator | QC | | 1642 | 1619 | 12 | 0.01 | 3.34 | 3.84 | 3.72 | 115M | 96720 | 1GB | 418 | 104MB | -13.64% | gc cr multi block request (1) |
| | | | | | | | | | | | | | | | | gc current multi block request (1) |
| | | | | | | | | | | | | | | | | os thread startup (3) |
| | | | | | | | | | | | | | | | | log file switch completion (1) |
| | | | | | | | | | | | | | | | | enq: FB - contention (1) |
| | | | | | | | | | | | | | | | | sql_id: g0p6hupu5my6d (1) |
| | | | | | | | | | | | | | | | | cell list of blocks physical read (2) |
| | | | | | | | | | | | | | | | | cell multiblock physical read (2) |
| | | | | | | | | | | | | | | | | cell single block physical read (5) |
| p000 | Set 1 | 1 | 228 | 32 | 196 | | 0.16 | 0.00 | | 5M | 52768 | 40GB | 10533 | 2GB | 83.69% | cell smart table scan (138) |
| | | | | | | | | | | | | | | | | direct path read temp (46) |
| | | | | | | | | | | | | | | | | direct path write temp (7) |
| p001 | Set 1 | 2 | 229 | 31 | 198 | | 0.17 | 0.00 | | 5M | 50741 | 38GB | 10517 | 2GB | 82.88% | cell smart table scan (134) |
| | | | | | | | | | | | | | | | | direct path read temp (56) |
| | | | | | | | | | | | | | | | | direct path write temp (9) |
| p002 | Set 1 | 3 | 230 | 31 | 198 | | 0.16 | 0.00 | | 5M | 52598 | 40GB | 10528 | 2GB | 83.63% | cell smart table scan (133) |
| | | | | | | | | | | | | | | | | direct path read temp (57) |
| | | | | | | | | | | | | | | | | direct path write temp (8) |
| p003 | Set 1 | 4 | 227 | 31 | 195 | | 0.15 | 0.00 | | 5M | 52646 | 40GB | 10522 | 2GB | 83.63% | cell smart table scan (137) |
| | | | | | | | | | | | | | | | | direct path read temp (47) |
| | | | | | | | | | | | | | | | | direct path write temp (6) |
| p004 | Set 1 | 5 | 226 | 32 | 194 | | 0.14 | 0.07 | | 5M | 52605 | 40GB | 10500 | 2GB | 83.63% | cell smart table scan (130) |
| | | | | | | | | | | | | | | | | direct path read temp (54) |
| | | | | | | | | | | | | | | | | direct path write temp (8) |
| p005 | Set 1 | 6 | 232 | 31 | 200 | | 0.16 | 0.07 | | 5M | 52900 | 40GB | 10536 | 2GB | 83.74% | cell smart table scan (136) |
| | | | | | | | | | | | | | | | | direct path read temp (48) |
| | | | | | | | | | | | | | | | | direct path write temp (12) |
| p006 | Set 1 | 7 | 229 | 32 | 197 | | 0.16 | | | 5M | 52534 | 40GB | 10519 | 2GB | 83.61% | cell smart table scan (136) |
| | | | | | | | | | | | | | | | | direct path read temp (54) |
| | | | | | | | | | | | | | | | | direct path write temp (4) |
| p007 | Set 1 | 8 | 228 | 31 | 197 | | 0.15 | | | 5M | 53783 | 41GB | 10505 | 2GB | 84.08% | cell smart table scan (135) |
| | | | | | | | | | | | | | | | | direct path read temp (48) |
| | | | | | | | | | | | | | | | | direct path write temp (10) |
| p008 | Set 1 | 9 | 231 | 31 | 200 | | 0.16 | | | 5M | 52571 | 40GB | 10551 | 2GB | 83.61% | cell smart table scan (134) |
| | | | | | | | | | | | | | | | | direct path read temp (48) |
| | | | | | | | | | | | | | | | | direct path write temp (12) |
| p009 | Set 1 | 10 | 230 | 32 | 198 | | 0.17 | | | 5M | 52772 | 40GB | 10521 | 2GB | 83.66% | cell smart table scan (135) |
| | | | | | | | | | | | | | | | | direct path read temp (49) |
| | | | | | | | | | | | | | | | | direct path write temp (15) |
| p010 | Set 1 | 11 | 232 | 32 | 200 | | 0.16 | | | 5M | 52107 | 39GB | 10473 | 2GB | 83.47% | cell smart table scan (139) |
| | | | | | | | | | | | | | | | | direct path read temp (56) |
| | | | | | | | | | | | | | | | | direct path write temp (13) |
| p011 | Set 1 | 12 | 229 | 31 | 197 | | 0.15 | | | 5M | 53881 | 41GB | 10492 | 2GB | 84.10% | cell smart table scan (134) |
| | | | | | | | | | | | | | | | | direct path read temp (48) |
| | | | | | | | | | | | | | | | | direct path write temp (7) |
| p012 | Set 1 | 13 | 224 | 32 | 192 | | 0.16 | | | 5M | 52631 | 40GB | 10550 | 2GB | 83.61% | cell smart table scan (131) |
| | | | | | | | | | | | | | | | | direct path read temp (45) |
| | | | | | | | | | | | | | | | | direct path write temp (11) |
| p013 | Set 1 | 14 | 225 | 32 | 193 | | 0.15 | 0.00 | | 5M | 52207 | 39GB | 10525 | 2GB | 83.47% | cell smart table scan (133) |
| | | | | | | | | | | | | | | | | direct path read temp (52) |
| | | | | | | | | | | | | | | | | direct path write temp (9) |
| p014 | Set 1 | 15 | 227 | 32 | 195 | | 0.16 | | | 5M | 52980 | 40GB | 10488 | 2GB | 83.77% | cell smart table scan (137) |
| | | | | | | | | | | | | | | | | direct path read temp (50) |
| | | | | | | | | | | | | | | | | direct path write temp (7) |
| p015 | Set 1 | 16 | 227 | 31 | 196 | | 0.17 | | | 5M | 50182 | 38GB | 10494 | 2GB | 82.70% | cell smart table scan (134) |
| | | | | | | | | | | | | | | | | direct path read temp (56) |
| | | | | | | | | | | | | | | | | direct path write temp (11) |
| p016 | Set 2 | 1 | 328 | 298 | 29 | | 0.15 | 0.78 | | 6M | 12139 | 724MB | 3368 | 671MB | -96.08% | gc current grant 2-way (1) |
| | | | | | | | | | | | | | | | | cell single block physical read (6) |
| | | | | | | | | | | | | | | | | direct path read temp (26) |
| p017 | Set 2 | 2 | 1168 | 1109 | 59 | | 0.00 | 0.70 | 0.02 | 6M | 19588 | 2GB | 8542 | 2GB | -100.00% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | gc current grant 2-way (1) |
| | | | | | | | | | | | | | | | | cell single block physical read (6) |
| | | | | | | | | | | | | | | | | direct path read temp (46) |
| | | | | | | | | | | | | | | | | direct path write temp (5) |
| p018 | Set 2 | 3 | 334 | 299 | 34 | | 0.15 | 0.85 | | 6M | 14772 | 1GB | 4590 | 901MB | -96.08% | cell single block physical read (10) |
| | | | | | | | | | | | | | | | | direct path read temp (28) |
| | | | | | | | | | | | | | | | | direct path write temp (3) |
| p019 | Set 2 | 4 | 1039 | 959 | 79 | | 0.16 | 0.82 | | 6M | 27631 | 3GB | 13732 | 3GB | -100.00% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | cell single block physical read (6) |
| | | | | | | | | | | | | | | | | direct path read temp (65) |
| | | | | | | | | | | | | | | | | direct path write temp (3) |
| p020 | Set 2 | 5 | 849 | 819 | 29 | | 0.16 | 0.73 | 0.05 | 6M | 12411 | 727MB | 3364 | 673MB | -96.08% | cell single block physical read (6) |
| | | | | | | | | | | | | | | | | direct path read temp (17) |
| | | | | | | | | | | | | | | | | direct path write temp (1) |
| p021 | Set 2 | 6 | 513 | 470 | 42 | | 0.14 | 0.92 | | 6M | 17066 | 1GB | 5859 | 1GB | -96.08% | cell single block physical read (6) |
| | | | | | | | | | | | | | | | | direct path read temp (31) |
| | | | | | | | | | | | | | | | | direct path write temp (2) |
| p022 | Set 2 | 7 | 372 | 334 | 37 | | 0.15 | 0.73 | | 6M | 14813 | 1GB | 5010 | 1GB | -96.08% | gc cr block busy (1) |
| | | | | | | | | | | | | | | | | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | cell single block physical read (7) |
| | | | | | | | | | | | | | | | | direct path read temp (30) |
| | | | | | | | | | | | | | | | | direct path write temp (2) |
| p023 | Set 2 | 8 | 697 | 632 | 64 | | 0.16 | 0.74 | | 6M | 22337 | 2GB | 10407 | 2GB | -100.00% | cell single block physical read (8) |
| | | | | | | | | | | | | | | | | direct path read temp (50) |
| | | | | | | | | | | | | | | | | direct path write temp (6) |
| p024 | Set 2 | 9 | 1122 | 1070 | 51 | | 0.16 | 0.85 | | 6M | 18632 | 1GB | 7342 | 1GB | -96.08% | cell single block physical read (10) |
| | | | | | | | | | | | | | | | | direct path read temp (44) |
| | | | | | | | | | | | | | | | | direct path write temp (6) |
| p025 | Set 2 | 10 | 1767 | 1684 | 81 | | 0.16 | 0.82 | 0.38 | 6M | 27926 | 3GB | 14010 | 3GB | -100.00% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | cell single block physical read (6) |
| | | | | | | | | | | | | | | | | direct path read temp (72) |
| | | | | | | | | | | | | | | | | direct path write temp (3) |
| | | | | | | | | | | | | | | | | read by other session (1) |
| p026 | Set 2 | 11 | 822 | 773 | 48 | | 0.16 | 0.78 | | 6M | 16989 | 1GB | 6657 | 1GB | -96.08% | gc current grant 2-way (2) |
| | | | | | | | | | | | | | | | | cell single block physical read (6) |
| | | | | | | | | | | | | | | | | direct path read temp (38) |
| | | | | | | | | | | | | | | | | direct path write temp (4) |
| p027 | Set 2 | 12 | 505 | 461 | 43 | | 0.16 | 0.72 | | 6M | 16014 | 1GB | 6201 | 1GB | -96.08% | cell single block physical read (8) |
| | | | | | | | | | | | | | | | | direct path read temp (34) |
| | | | | | | | | | | | | | | | | direct path write temp (3) |
| | | | | | | | | | | | | | | | | read by other session (1) |
| p028 | Set 2 | 13 | 1002 | 941 | 59 | | 0.16 | 0.76 | | 6M | 19785 | 2GB | 8537 | 2GB | -100.00% | gc cr grant 2-way (2) |
| | | | | | | | | | | | | | | | | cell single block physical read (9) |
| | | | | | | | | | | | | | | | | direct path read temp (55) |
| | | | | | | | | | | | | | | | | direct path write temp (1) |
| p029 | Set 2 | 14 | 631 | 587 | 43 | | 0.16 | 0.89 | | 6M | 17071 | 1GB | 6004 | 1GB | -96.08% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | gc current grant 2-way (1) |
| | | | | | | | | | | | | | | | | cell single block physical read (5) |
| | | | | | | | | | | | | | | | | direct path read temp (30) |
| | | | | | | | | | | | | | | | | direct path write temp (6) |
| p030 | Set 2 | 15 | 644 | 588 | 55 | | 0.16 | 0.70 | | 6M | 19257 | 2GB | 8526 | 2GB | -100.00% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | cell single block physical read (8) |
| | | | | | | | | | | | | | | | | direct path read temp (46) |
| | | | | | | | | | | | | | | | | direct path write temp (5) |
| p031 | Set 2 | 16 | 471 | 416 | 54 | | 0.16 | 0.73 | | 6M | 18998 | 2GB | 8125 | 2GB | -100.00% | gc current grant 2-way (1) |
| | | | | | | | | | | | | | | | | cell single block physical read (9) |
| | | | | | | | | | | | | | | | | direct path read temp (32) |
| | | | | | | | | | | | | | | | | direct path write temp (6) |
=================================================================================================================================================================================================================
SQL Plan Monitoring Details (Plan Hash Value=2056239125)
=================================================================================================================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Write | Write | Cell | Mem | Temp | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | Offload | (Max) | (Max) | (%) | (# samples) |
=================================================================================================================================================================================================================================================================================
| 0 | INSERT STATEMENT | | | | 2844 | +196 | 1 | 0 | | | | | | | | 0.02 | Cpu (3) |
| 1 | TEMP TABLE TRANSFORMATION | | | | | | 1 | | | | | | | | | | |
| 2 | LOAD AS SELECT | | | | 8 | +3 | 1 | 1 | | | | | | 543K | | 0.01 | Cpu (2) |
| 3 | WINDOW SORT | | 10647 | 1653 | 7 | +4 | 1 | 1M | | | | | | 74M | | 0.01 | Cpu (2) |
| 4 | VIEW | | 10647 | 1652 | 1 | +10 | 1 | 1M | | | | | | | | | |
| 5 | NESTED LOOPS | | 10647 | 1652 | 1 | +10 | 1 | 1M | | | | | | | | | |
| 6 | VIEW | | 1 | 2 | 1 | +10 | 1 | 18 | | | | | | | | | |
| 7 | COUNT | | | | 1 | +10 | 1 | 18 | | | | | | | | | |
| 8 | CONNECT BY WITHOUT FILTERING | | | | 1 | +10 | 1 | 18 | | | | | | | | | |
| 9 | FAST DUAL | | 1 | 2 | 1 | +10 | 1 | 1 | | | | | | | | | |
| 10 | TABLE ACCESS STORAGE FULL | CP | 10647 | 1650 | 10 | +1 | 18 | 1M | | | | | | | | 0.01 | Cpu (2) |
| 11 | LOAD TABLE CONVENTIONAL | | | | 1618 | +2003 | 1 | 0 | 12331 | 96MB | | | | | | 9.14 | gc current multi block request (1) |
| | | | | | | | | | | | | | | | | | log file switch completion (1) |
| | | | | | | | | | | | | | | | | | Cpu (1593) |
| | | | | | | | | | | | | | | | | | enq: FB - contention (1) |
| | | | | | | | | | | | | | | | | | cell single block physical read (4) |
| 12 | PX COORDINATOR | | | | 3614 | +7 | 33 | 12M | | | | | | | | 0.09 | os thread startup (3) |
| | | | | | | | | | | | | | | | | | Cpu (13) |
| 13 | PX SEND QC (RANDOM) | :TQ10013 | 359 | 3M | 1618 | +2003 | 16 | 12M | | | | | | | | 0.01 | Cpu (2) |
| 14 | HASH GROUP BY | | 359 | 3M | 1619 | +2002 | 16 | 12M | | | | | | 2G | | 0.05 | Cpu (8) |
| 15 | PX RECEIVE | | 359 | 3M | 1417 | +2002 | 16 | 12M | | | | | | | | 0.01 | Cpu (1) |
| 16 | PX SEND HASH | :TQ10012 | 359 | 3M | 1 | +2002 | 16 | 12M | | | | | | | | 0.04 | Cpu (7) |
| 17 | HASH GROUP BY | | 359 | 3M | 24 | +1979 | 16 | 12M | | | | | | 2G | | 0.23 | Cpu (41) |
| 18 | HASH JOIN | | 10M | 3M | 24 | +1979 | 16 | 37M | | | | | | 447M | | 0.07 | Cpu (12) |
| 19 | BUFFER SORT | | | | 9 | +1972 | 16 | 4M | | | | | | 151M | | | |
| 20 | PX RECEIVE | | 4M | 30619 | 9 | +1972 | 16 | 4M | | | | | | | | | |
| 21 | PX SEND HASH | :TQ10006 | 4M | 30619 | 32 | +1970 | 1 | 4M | | | | | | | | | |
| 22 | PARTITION HASH ALL | | 4M | 30619 | 32 | +1970 | 1 | 4M | | | | | | | | | |
| 23 | TABLE ACCESS STORAGE FULL | DPM | 4M | 30619 | 32 | +1970 | 1024 | 4M | 83652 | 665MB | | | | | | 0.03 | Cpu (3) |
| | | | | | | | | | | | | | | | | | cell list of blocks physical read (2) |
| | | | | | | | | | | | | | | | | | cell single block physical read (1) |
| 24 | PX RECEIVE | | 9M | 3M | 24 | +1979 | 16 | 37M | | | | | | | | 0.05 | Cpu (8) |
| 25 | PX SEND HASH | :TQ10011 | 9M | 3M | 25 | +1978 | 16 | 37M | | | | | | | | 0.05 | Cpu (8) |
| 26 | VIEW | | 9M | 3M | 25 | +1978 | 16 | 37M | | | | | | | | 0.12 | Cpu (21) |
| 27 | WINDOW SORT PUSHED RANK | | 9M | 3M | 110 | +1893 | 16 | 70M | 162K | 19GB | 120K | 19GB | | 2G | 11G | 4.68 | Cpu (234) |
| | | | | | | | | | | | | | | | | | direct path read temp (478) |
| | | | | | | | | | | | | | | | | | direct path write temp (108) |
| 28 | PX RECEIVE | | 9M | 3M | 86 | +1893 | 16 | 70M | | | | | | | | 0.11 | Cpu (19) |
| 29 | PX SEND HASH | :TQ10010 | 9M | 3M | 77 | +1893 | 16 | 70M | | | | | | | | 0.25 | Cpu (43) |
| 30 | WINDOW CHILD PUSHED RANK | | 9M | 3M | 1752 | +218 | 16 | 70M | 146K | 19GB | 101K | 19GB | | 4G | 10G | 41.97 | Cpu (6748) |
| | | | | | | | | | | | | | | | | | direct path read temp (553) |
| | | | | | | | | | | | | | | | | | direct path write temp (47) |
| 31 | HASH JOIN RIGHT OUTER | | 9M | 2M | 1676 | +218 | 16 | 7G | | | | | | 217M | | 23.08 | Cpu (4041) |
| 32 | BUFFER SORT | | | | 4 | +216 | 16 | 1M | | | | | | 97M | | | |
| 33 | PX RECEIVE | | 10647 | 24 | 4 | +216 | 16 | 1M | | | | | | | | | |
| 34 | PX SEND HASH | :TQ10005 | 10647 | 24 | 1633 | +216 | 1 | 1M | | | | | | | | 0.01 | Cpu (2) |
| 35 | VIEW | | 10647 | 24 | 1632 | +217 | 1 | 1M | | | | | | | | | |
| 36 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FDA1E71E_D71F1BDE | 10647 | 24 | 1632 | +217 | 1 | 1M | 106 | 104MB | | | | | | 0.01 | cell multiblock physical read (1) |
| 37 | PX RECEIVE | | 9M | 2M | 1676 | +218 | 16 | 37M | | | | | | | | 0.05 | Cpu (9) |
| 38 | PX SEND HASH | :TQ10009 | 9M | 2M | 1677 | +217 | 16 | 37M | | | | | | | | 0.13 | Cpu (23) |
| 39 | VIEW | | 9M | 2M | 1677 | +217 | 16 | 37M | | | | | | | | | |
| 40 | SORT UNIQUE | | 9M | 2M | 1701 | +193 | 16 | 37M | 48155 | 7GB | 47883 | 7GB | | 2G | 4G | 2.84 | Cpu (121) |
| | | | | | | | | | | | | | | | | | direct path read temp (336) |
| | | | | | | | | | | | | | | | | | direct path write temp (41) |
| 41 | PX RECEIVE | | | | 15 | +193 | 16 | 37M | | | | | | | | 0.07 | Cpu (12) |
| 42 | PX SEND HASH | :TQ10008 | | | 23 | +193 | 16 | 37M | | | | | | | | 0.13 | Cpu (22) |
| 43 | BUFFER SORT | | 7G | | 197 | +19 | 16 | 37M | 33844 | 4GB | 18803 | 4GB | | 2G | 4G | 0.77 | Cpu (35) |
| | | | | | | | | | | | | | | | | | direct path read temp (91) |
| | | | | | | | | | | | | | | | | | direct path write temp (9) |
| 44 | UNION-ALL | | | | 177 | +19 | 16 | 37M | | | | | | | | 0.18 | Cpu (32) |
| 45 | BUFFER SORT | | | | 3 | +18 | 16 | 3M | | | | | | 443M | | | |
| 46 | PX RECEIVE | | | | 3 | +18 | 16 | 3M | | | | | | | | | |
| 47 | PX SEND ROUND-ROBIN | :TQ10003 | | | 4 | +17 | 1 | 3M | | | | | | | | 0.01 | Cpu (1) |
| 48 | TABLE ACCESS STORAGE FULL | PTFRTS_GTT | 3M | 12005 | 3 | +18 | 1 | 3M | | | | | | | | | |
| 49 | NESTED LOOPS OUTER | | 6M | 2M | 36 | +160 | 16 | 33M | | | | | | | | | |
| 50 | HASH JOIN OUTER | | 2M | 2M | 178 | +18 | 16 | 33M | | | | | | 6G | | 0.42 | Cpu (74) |
| 51 | PX RECEIVE | | 2M | 2M | 138 | +19 | 16 | 33M | | | | | | | | 0.06 | Cpu (11) |
| 52 | PX SEND HASH | :TQ10007 | 2M | 2M | 176 | +18 | 16 | 33M | | | | | | | | 0.13 | Cpu (22) |
| 53 | HASH JOIN | | 2M | 2M | 181 | +13 | 16 | 33M | | | | | | 27M | | 0.03 | Cpu (6) |
| 54 | BUFFER SORT | | | | 6 | +13 | 16 | 18352 | | | | | | 918K | | | |
| 55 | PX RECEIVE | | 1147 | 9 | 6 | +13 | 16 | 18352 | | | | | | | | | |
| 56 | PX SEND BROADCAST | :TQ10000 | 1147 | 9 | 1 | +12 | 1 | 18352 | | | | | | | | | |
| 57 | VIEW | index$_join$_012 | 1147 | 9 | 1 | +12 | 1 | 1147 | | | | | | | | | |
| 58 | HASH JOIN | | | | 1 | +12 | 1 | 1147 | | | | | | 2M | | | |
| 59 | INDEX STORAGE FAST FULL SCAN | DCT_PK | 1147 | 5 | 1 | +12 | 1 | 1147 | | | | | | | | | |
| 60 | INDEX STORAGE FAST FULL SCAN | DCT_UK | 1147 | 6 | 1 | +12 | 1 | 1147 | | | | | | | | | |
| 61 | HASH JOIN | | 2M | 2M | 181 | +13 | 16 | 33M | | | | | | 20M | | 0.04 | Cpu (7) |
| 62 | BUFFER SORT | | | | 6 | +13 | 16 | 144 | | | | | | 32768 | | | |
| 63 | PX RECEIVE | | 9 | 2 | 6 | +13 | 16 | 144 | | | | | | | | | |
| 64 | PX SEND BROADCAST | :TQ10001 | 9 | 2 | 1 | +12 | 1 | 144 | | | | | | | | | |
| 65 | VIEW | index$_join$_014 | 9 | 2 | 1 | +12 | 1 | 9 | | | | | | | | | |
| 66 | HASH JOIN | | | | 1 | +12 | 1 | 9 | | | | | | 1M | | | |
| 67 | INDEX STORAGE FAST FULL SCAN | DRT_PK | 9 | 1 | 1 | +12 | 1 | 9 | | | | | | | | | |
| 68 | INDEX STORAGE FAST FULL SCAN | DRT_UK | 9 | 1 | 1 | +12 | 1 | 9 | | | | | | | | | |
| 69 | HASH JOIN | | 2M | 2M | 181 | +13 | 16 | 33M | | | | | | 14M | | 0.03 | Cpu (6) |
| 70 | BUFFER SORT | | | | 6 | +13 | 16 | 32 | | | | | | 32768 | | | |
| 71 | PX RECEIVE | | 2 | 1 | 6 | +13 | 16 | 32 | | | | | | | | | |
| 72 | PX SEND BROADCAST | :TQ10002 | 2 | 1 | 1 | +12 | 1 | 32 | | | | | | | | | |
| 73 | VIEW | index$_join$_010 | 2 | 1 | 1 | +12 | 1 | 2 | | | | | | | | | |
| 74 | HASH JOIN | | | | 1 | +12 | 1 | 2 | | | | | | 883K | | | |
| 75 | INLIST ITERATOR | | | | 1 | +12 | 1 | 2 | | | | | | | | | |
| 76 | INDEX UNIQUE SCAN | DA_UK | 2 | | 1 | +12 | 2 | 2 | | | | | | | | | |
| 77 | INDEX STORAGE FAST FULL SCAN | DA_PK | 2 | 1 | 1 | +12 | 1 | 10 | | | | | | | | | |
| 78 | PX PARTITION HASH ALL | | 8M | 2M | 181 | +13 | 16 | 39M | | | | | | | | | |
| 79 | TABLE ACCESS STORAGE FULL | T | 8M | 2M | 184 | +10 | 2048 | 39M | 630K | 610GB | | | 99.66% | 118M | | 12.41 | Cpu (17) |
| | | | | | | | | | | | | | | | | | cell smart table scan (2156) |
| 80 | BUFFER SORT | | | | 7 | +155 | 16 | 5M | | | | | | 412M | | 0.01 | Cpu (1) |
| 81 | PX RECEIVE | | 46M | 184K | 6 | +155 | 16 | 5M | | | | | | | | | |
| 82 | PX SEND HASH | :TQ10004 | 46M | 184K | 36 | +156 | 1 | 5M | | | | | | | | | |
| 83 | PARTITION LIST ALL | | 46M | 184K | 36 | +156 | 1 | 5M | | | | | | | | | |
| 84 | TABLE ACCESS STORAGE FULL | TP_RT | 46M | 184K | 38 | +154 | 3 | 5M | 525 | 514MB | | | | | | 0.02 | gc cr multi block request (1) |
| | | | | | | | | | | | | | | | | | Cpu (2) |
| | | | | | | | | | | | | | | | | | cell multiblock physical read (1) |
| 85 | PARTITION LIST ITERATOR | | 4 | 3 | 36 | +160 | 33M | 33M | | | | | | | | 0.14 | Cpu (24) |
| 86 | PARTITION HASH ITERATOR | | 4 | 3 | 36 | +160 | 33M | 33M | | | | | | | | 0.15 | Cpu (26) |
| 87 | INDEX RANGE SCAN | TX_PN_PK | 4 | 3 | 37 | +159 | 33M | 33M | 116K | 906MB | | | | | | 2.32 | gc cr block busy (1) |
| | | | | | | | | | | | | | | | | | gc cr grant 2-way (8) |
| | | | | | | | | | | | | | | | | | gc current grant 2-way (6) |
| | | | | | | | | | | | | | | | | | Cpu (274) |
| | | | | | | | | | | | | | | | | | cell single block physical read (116) |
| | | | | | | | | | | | | | | | | | read by other session (2) |
=================================================================================================================================================================================================================================================================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment