Skip to content

Instantly share code, notes, and snippets.

@databasetech0073

databasetech0073/gist:05a8ccfb7022eb9dadb508d40286edb3 Secret

Created November 10, 2022 19:34
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/05a8ccfb7022eb9dadb508d40286edb3 to your computer and use it in GitHub Desktop.
Save databasetech0073/05a8ccfb7022eb9dadb508d40286edb3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
********************* Execution which is failing in 19.15 version with high tempspace consumption**********************
Global Information
------------------------------
Status : DONE (ERROR)
Instance ID : 1
SQL Execution ID : 16777233
Execution Started : 10/06/2022 12:03:33
First Refresh Time : 10/06/2022 12:03:39
Last Refresh Time : 10/06/2022 12:18:47
Duration : 914s
PLSQL Entry Ids (Object/Subprogram) : 25723986,1
PLSQL Current Ids (Object/Subprogram) : 25723986,1
Binds
========================================================================================================================
| Name | Position | Type | Value |
========================================================================================================================
| :B1 | 1 | DATE | 10/05/2022 00:00:00 |
========================================================================================================================
Global Stats
========================================================================================================================================================
| Elapsed | Cpu | IO | Application | Concurrency | Cluster | Other | Buffer | Read | Read | Write | Write | Offload | Offload |
| Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Gets | Reqs | Bytes | Reqs | Bytes | Elig Bytes | Returned Bytes |
========================================================================================================================================================
| 40830 | 33370 | 7451 | 0.07 | 1.32 | 6.98 | 0.17 | 269M | 1M | 904GB | 3M | 1TB | 891GB | 4TB |
========================================================================================================================================================
Parallel Execution Details (DOP=16 , Servers Allocated=32)
===================================================================================================================================================================================================================================================================================
| Name | Type | Server# | Elapsed | Cpu | IO | Application | Concurrency | Cluster | Other | Buffer | Read | Read | Write | Write | Offload | Offload | Wait Events | |
| | | | Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Gets | Reqs | Bytes | Reqs | Bytes | Elig Bytes | Returned Bytes | (sample #) | |
===================================================================================================================================================================================================================================================================================
| PX Coordinator | QC | | 61 | 49 | 12 | 0.07 | 0.00 | 0.28 | | 2M | 6355 | 4GB | 1274 | 835MB | 3GB | 5GB | cell multiblock physical read (5) | |
| | | | | | | | | | | | | | | | | | cell smart table scan (1) | |
| | | | | | | | | | | | | | | | | | direct path read temp (5) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01c | Set 1 | 1 | 802 | 779 | 23 | | | 0.00 | | 9M | 68338 | 66GB | 1197 | 599MB | 65GB | 66GB | ASM IO for non-blocking poll (1) | |
| | | | | | | | | | | | | | | | | | cell smart table scan (11) | |
| | | | | | | | | | | | | | | | | | direct path read temp (8) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01d | Set 1 | 2 | 664 | 643 | 21 | | | 0.01 | | 7M | 60061 | 58GB | 1197 | 598MB | 57GB | 58GB | cell smart table scan (10) | |
| | | | | | | | | | | | | | | | | | direct path read temp (9) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01e | Set 1 | 3 | 657 | 635 | 22 | | | 0.01 | 0.12 | 7M | 59641 | 57GB | 1195 | 598MB | 57GB | 58GB | cell smart table scan (6) | |
| | | | | | | | | | | | | | | | | | direct path read temp (6) | |
| | | | | | | | | | | | | | | | | | direct path write temp (4) | |
| p01f | Set 1 | 4 | 630 | 610 | 20 | | | 0.00 | | 7M | 57234 | 55GB | 1197 | 599MB | 55GB | 56GB | cell smart table scan (8) | |
| | | | | | | | | | | | | | | | | | direct path read temp (6) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01g | Set 1 | 5 | 637 | 617 | 20 | | | 0.00 | 0.05 | 7M | 57474 | 55GB | 1195 | 598MB | 55GB | 56GB | cell smart table scan (11) | |
| | | | | | | | | | | | | | | | | | direct path read temp (6) | |
| | | | | | | | | | | | | | | | | | direct path write temp (2) | |
| p01h | Set 1 | 6 | 615 | 595 | 20 | | | 0.00 | | 7M | 54957 | 53GB | 1197 | 598MB | 52GB | 54GB | cell smart table scan (13) | |
| | | | | | | | | | | | | | | | | | direct path read temp (5) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01i | Set 1 | 7 | 630 | 608 | 22 | | | 0.00 | | 7M | 56643 | 55GB | 1199 | 599MB | 54GB | 55GB | cell smart table scan (15) | |
| | | | | | | | | | | | | | | | | | direct path read temp (8) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01j | Set 1 | 8 | 638 | 619 | 19 | | | 0.00 | | 7M | 58257 | 56GB | 1197 | 598MB | 56GB | 57GB | cell smart table scan (6) | |
| | | | | | | | | | | | | | | | | | direct path read temp (4) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01k | Set 1 | 9 | 628 | 608 | 20 | | | | | 7M | 57537 | 55GB | 1197 | 599MB | 55GB | 56GB | cell smart table scan (7) | |
| | | | | | | | | | | | | | | | | | direct path read temp (4) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01l | Set 1 | 10 | 628 | 607 | 20 | | | 0.00 | | 7M | 56535 | 54GB | 1195 | 598MB | 54GB | 55GB | cell smart table scan (10) | |
| | | | | | | | | | | | | | | | | | direct path read temp (6) | |
| | | | | | | | | | | | | | | | | | direct path write temp (2) | |
| p01m | Set 1 | 11 | 616 | 597 | 19 | | | 0.00 | | 7M | 56525 | 54GB | 1195 | 598MB | 54GB | 55GB | cell smart table scan (5) | |
| | | | | | | | | | | | | | | | | | direct path read temp (6) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01n | Set 1 | 12 | 636 | 617 | 19 | | | 0.01 | | 7M | 59653 | 57GB | 1196 | 598MB | 57GB | 58GB | cell smart table scan (3) | |
| | | | | | | | | | | | | | | | | | direct path read temp (5) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01o | Set 1 | 13 | 637 | 617 | 19 | | | 0.00 | | 7M | 57147 | 55GB | 1197 | 598MB | 55GB | 56GB | cell smart table scan (7) | |
| | | | | | | | | | | | | | | | | | direct path read temp (7) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01p | Set 1 | 14 | 634 | 615 | 19 | | | | | 7M | 57479 | 55GB | 1197 | 598MB | 55GB | 56GB | cell smart table scan (10) | |
| | | | | | | | | | | | | | | | | | direct path read temp (4) | |
| | | | | | | | | | | | | | | | | | direct path write temp (1) | |
| p01q | Set 1 | 15 | 617 | 596 | 21 | | | 0.00 | | 7M | 55259 | 53GB | 1197 | 598MB | 53GB | 54GB | ASM IO for non-blocking poll (1) | |
| | | | | | | | | | | | | | | | | | cell smart table scan (10) | |
| | | | | | | | | | | | | | | | | | direct path read temp (7) | |
| | | | | | | | | | | | | | | | | | direct path write temp (3) | |
| p01r | Set 1 | 16 | 637 | 617 | 20 | | | | | 7M | 57704 | 56GB | 1197 | 599MB | 55GB | 56GB | cell smart table scan (6) | |
| | | | | | | | | | | | | | | | | | direct path read temp (6) | |
| | | | | | | | | | | | | | | | | | direct path write temp (2) | |
| p01s | Set 2 | 1 | 1508 | 1154 | 353 | | 0.00 | 0.42 | | 9M | 11840 | 387MB | 148K | 72GB | . | 145GB | NaN% | cell single block physical read: flash cache (5) |
| | | | | | | | | | | | | | | | | | | direct path read temp (3) |
| p01t | Set 2 | 2 | 2166 | 1641 | 525 | | 0.23 | 0.41 | | 9M | 11740 | 386MB | 224K | 110GB | . | 219GB | NaN% | cell single block physical read: flash cache (6) |
| | | | | | | | | | | | | | | | | | | direct path read temp (5) |
| p01u | Set 2 | 3 | 1419 | 1069 | 350 | | | 0.41 | | 9M | 11927 | 388MB | 135K | 66GB | . | 132GB | NaN% | cell single block physical read: flash cache (4) |
| | | | | | | | | | | | | | | | | | | direct path read temp (5) |
| | | | | | | | | | | | | | | | | | | direct path write temp (2) |
| p01v | Set 2 | 4 | 2197 | 1675 | 522 | | 0.00 | 0.42 | | 9M | 12036 | 389MB | 217K | 106GB | . | 212GB | NaN% | cell single block physical read: flash cache (6) |
| | | | | | | | | | | | | | | | | | | direct path read temp (4) |
| p01w | Set 2 | 5 | 1995 | 1516 | 478 | | 0.10 | 0.41 | | 9M | 11463 | 384MB | 194K | 95GB | . | 190GB | NaN% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (5) |
| | | | | | | | | | | | | | | | | | | direct path read temp (4) |
| p01x | Set 2 | 6 | 2475 | 1890 | 584 | | 0.00 | 0.44 | | 9M | 12006 | 388MB | 240K | 118GB | . | 236GB | NaN% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (5) |
| | | | | | | | | | | | | | | | | | | direct path read temp (5) |
| | | | | | | | | | | | | | | | | | | direct path write temp (2) |
| p01y | Set 2 | 7 | 1257 | 956 | 301 | | 0.00 | 0.42 | | 9M | 11931 | 388MB | 118K | 58GB | . | 116GB | NaN% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (7) |
| | | | | | | | | | | | | | | | | | | direct path read temp (6) |
| | | | | | | | | | | | | | | | | | | direct path write temp (2) |
| p01z | Set 2 | 8 | 1934 | 1472 | 461 | | 0.21 | 0.43 | | 9M | 12067 | 388MB | 187K | 93GB | . | 186GB | NaN% | cell single block physical read: flash cache (2) |
| | | | | | | | | | | | | | | | | | | direct path read temp (1) |
| p020 | Set 2 | 9 | 1624 | 1222 | 402 | | 0.00 | 0.41 | | 9M | 11488 | 385MB | 154K | 76GB | . | 151GB | NaN% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (5) |
| | | | | | | | | | | | | | | | | | | direct path read temp (4) |
| | | | | | | | | | | | | | | | | | | direct path write temp (2) |
| p021 | Set 2 | 10 | 1521 | 1163 | 357 | | 0.23 | 0.41 | | 9M | 11617 | 385MB | 146K | 72GB | . | 143GB | NaN% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (3) |
| | | | | | | | | | | | | | | | | | | direct path read temp (5) |
| | | | | | | | | | | | | | | | | | | direct path write temp (1) |
| p022 | Set 2 | 11 | 1198 | 920 | 278 | | 0.10 | 0.42 | | 9M | 11933 | 388MB | 116K | 57GB | . | 114GB | NaN% | cell single block physical read: flash cache (6) |
| | | | | | | | | | | | | | | | | | | direct path read temp (6) |
| p023 | Set 2 | 12 | 2499 | 1920 | 578 | | 0.01 | 0.46 | | 9M | 12284 | 390MB | 253K | 124GB | . | 247GB | NaN% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (4) |
| | | | | | | | | | | | | | | | | | | direct path read temp (4) |
| p024 | Set 2 | 13 | 1940 | 1501 | 439 | | 0.10 | 0.41 | | 9M | 11561 | 385MB | 193K | 94GB | . | 189GB | NaN% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (4) |
| | | | | | | | | | | | | | | | | | | direct path read temp (4) |
| | | | | | | | | | | | | | | | | | | direct path write temp (1) |
| p025 | Set 2 | 14 | 3093 | 2465 | 627 | | 0.00 | 0.39 | | 9M | 11658 | 386MB | 325K | 159GB | . | 318GB | NaN% | cell single block physical read: flash cache (8) |
| | | | | | | | | | | | | | | | | | | direct path read temp (3) |
| | | | | | | | | | | | | | | | | | | direct path write temp (1) |
| p026 | Set 2 | 15 | 1401 | 1076 | 325 | | 0.10 | 0.41 | | 9M | 11536 | 385MB | 140K | 68GB | . | 137GB | NaN% | gc cr grant 2-way (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (4) |
| | | | | | | | | | | | | | | | | | | direct path read temp (8) |
| | | | | | | | | | | | | | | | | | | direct path write temp (2) |
| p027 | Set 2 | 16 | 2239 | 1700 | 538 | | 0.23 | 0.41 | | 9M | 11957 | 388MB | 226K | 110GB | . | 221GB | NaN% | ASM IO for non-blocking poll (1) |
| | | | | | | | | | | | | | | | | | | cell single block physical read: flash cache (3) |
| | | | | | | | | | | | | | | | | | | direct path read temp (4) |
===================================================================================================================================================================================================================================================================================
SQL Plan Monitoring Details (Plan Hash Value=3957617523)
===================================================================================================================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Write | Write | Mem | Temp | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | (Max) | (Max) | (%) | (# samples) |
===================================================================================================================================================================================================================================================================================
| 0 | INSERT STATEMENT | | | | | | 1 | | | | | | . | . | | |
| 1 | TEMP TABLE TRANSFORMATION | | | | | | 1 | | | | | | . | . | | |
| 2 | LOAD AS SELECT | SYS_TEMP_0FD9D6D1B_38C7BCF3 | | | 25 | +12 | 1 | 2 | | | 397 | 397MB | . | . | 0.07 | Cpu (8) |
| 3 | WINDOW SORT | | 30888 | 4547 | 35 | +2 | 1 | 4M | 2412 | 439MB | 877 | 439MB | 98MB | 226MB | 0.14 | Cpu (10) |
| | | | | | | | | | | | | | | | | direct path read temp (5) |
| | | | | | | | | | | | | | | | | direct path write temp (1) |
| 4 | VIEW | | 30888 | 4152 | 3 | +6 | 1 | 4M | | | | | . | . | | |
| 5 | NESTED LOOPS | | 30888 | 4152 | 5 | +6 | 1 | 4M | | | | | . | . | | |
| 6 | VIEW | | 1 | 2 | 5 | +6 | 1 | 18 | | | | | . | . | | |
| 7 | COUNT | | | | 5 | +6 | 1 | 18 | | | | | . | . | | |
| 8 | CONNECT BY WITHOUT FILTERING | | | | 5 | +6 | 1 | 18 | | | | | 2048 | . | | |
| 9 | FAST DUAL | | 1 | 2 | 1 | +6 | 1 | 1 | | | | | . | . | | |
| 10 | TABLE ACCESS STORAGE FULL | CP | 30888 | 4150 | 8 | +1 | 18 | 4M | 147 | 141MB | | | . | . | 0.04 | Cpu (4) |
| 11 | LOAD TABLE CONVENTIONAL | BINTS_FACT | | | | | 1 | | | | | | . | . | | |
| 12 | PX COORDINATOR | | | | | | 33 | | | | | | . | . | | |
| 13 | PX SEND QC (RANDOM) | :TQ10013 | 364 | 4M | | | | | | | | | . | . | | |
| 14 | HASH GROUP BY | | 364 | 4M | | | | | | | | | . | . | | |
| 15 | PX RECEIVE | | 364 | 4M | | | | | | | | | . | . | | |
| 16 | PX SEND HASH | :TQ10012 | 364 | 4M | | | | | | | | | . | . | | |
| 17 | HASH GROUP BY | | 364 | 4M | | | | | | | | | . | . | | |
| 18 | HASH JOIN | | 10M | 4M | | | | | | | | | . | . | | |
| 19 | BUFFER SORT | | | | | | | | | | | | . | . | | |
| 20 | PX RECEIVE | | 4M | 30627 | | | | | | | | | . | . | | |
| 21 | PX SEND HASH | :TQ10006 | 4M | 30627 | | | | | | | | | . | . | | |
| 22 | PARTITION HASH ALL | | 4M | 30627 | | | | | | | | | . | . | | |
| 23 | TABLE ACCESS STORAGE FULL | DPM | 4M | 30627 | | | | | | | | | . | . | | |
| 24 | PX RECEIVE | | 9M | 4M | | | | | | | | | . | . | | |
| 25 | PX SEND HASH | :TQ10011 | 9M | 4M | | | | | | | | | . | . | | |
| 26 | VIEW | | 9M | 4M | | | | | | | | | . | . | | |
| 27 | WINDOW SORT PUSHED RANK | | 9M | 4M | | | | | | | | | . | . | | |
| 28 | PX RECEIVE | | 9M | 4M | | | | | | | | | . | . | | |
| 29 | PX SEND HASH | :TQ10010 | 9M | 4M | | | 16 | | | | | | . | . | | |
| 30 | WINDOW CHILD PUSHED RANK | | 9M | 4M | 3112 | +915 | 16 | 0 | | | 3M | 1TB | 9GB | 1TB | 0.06 | Cpu (7) |
| 31 | HASH JOIN RIGHT OUTER | | 9M | 3M | 3112 | +915 | 16 | 10G | | | | | 648MB | . | 0.08 | Cpu (9) |
| 32 | BUFFER SORT | | | | 8 | +908 | 16 | 4M | | | | | 350MB | . | 0.01 | Cpu (1) |
| 33 | PX RECEIVE | | 30888 | 66 | 7 | +909 | 16 | 4M | | | | | . | . | | |
| 34 | PX SEND HASH | :TQ10005 | 30888 | 66 | 7 | +908 | 1 | 4M | | | | | . | . | 0.01 | Cpu (1) |
| 35 | VIEW | | 30888 | 66 | 7 | +908 | 1 | 4M | | | | | . | . | | |
| 36 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D6D1B_38C7BCF3 | 30888 | 66 | 7 | +908 | 1 | 4M | 396 | 395MB | | | . | . | 0.05 | Cpu (1) |
| | | | | | | | | | | | | | | | | cell multiblock physical read (5) |
| 37 | PX RECEIVE | | 9M | 3M | 3112 | +915 | 16 | 18M | | | | | . | . | | |
| 38 | PX SEND HASH | :TQ10009 | 9M | 3M | 3113 | +914 | 16 | 18M | | | | | . | . | | |
| 39 | VIEW | | 9M | 3M | 3113 | +914 | 16 | 18M | | | | | . | . | | |
| 40 | SORT UNIQUE | | 9M | 3M | 3143 | +884 | 16 | 18M | 13636 | 7GB | 19145 | 9GB | 2GB | 5GB | 2.78 | Cpu (191) |
| | | | | | | | | | | | | | | | | ASM IO for non-blocking poll (2) |
| | | | | | | | | | | | | | | | | direct path read temp (97) |
| | | | | | | | | | | | | | | | | direct path write temp (24) |
| 41 | PX RECEIVE | | | | 16 | +884 | 16 | 47M | | | | | . | . | 0.07 | Cpu (8) |
| 42 | PX SEND HASH | :TQ10008 | | | 25 | +883 | 16 | 47M | | | | | . | . | 0.29 | Cpu (33) |
| 43 | BUFFER SORT | | 7G | | 681 | +227 | 16 | 47M | 9574 | 5GB | 9570 | 5GB | 2GB | 5GB | 1.36 | Cpu (69) |
| | | | | | | | | | | | | | | | | ASM IO for non-blocking poll (1) |
| | | | | | | | | | | | | | | | | direct path read temp (71) |
| | | | | | | | | | | | | | | | | direct path write temp (13) |
| 44 | UNION-ALL | | | | 659 | +227 | 16 | 47M | | | | | . | . | 0.30 | Cpu (34) |
| 45 | BUFFER SORT | | | | 3 | +225 | 16 | 3M | | | | | 427MB | . | | |
| 46 | PX RECEIVE | | | | 3 | +225 | 16 | 3M | | | | | . | . | | |
| 47 | PX SEND ROUND-ROBIN | :TQ10003 | | | 16 | +224 | 1 | 3M | | | | | . | . | 0.02 | Cpu (2) |
| 48 | TABLE ACCESS STORAGE FULL | PTFRTS_GTT | 3M | 12152 | 16 | +224 | 1 | 3M | 351 | 348MB | | | 7MB | . | | |
| 49 | NESTED LOOPS OUTER | | 6M | 3M | 51 | +835 | 16 | 43M | | | | | . | . | 0.02 | Cpu (2) |
| 50 | HASH JOIN OUTER | | 2M | 3M | 659 | +227 | 16 | 43M | | | | | 7GB | . | 0.74 | Cpu (83) |
| 51 | PX RECEIVE | | 2M | 2M | 587 | +227 | 16 | 43M | | | | | . | . | 0.18 | Cpu (20) |
| 52 | PX SEND HASH | :TQ10007 | 2M | 2M | 659 | +225 | 16 | 43M | | | | | . | . | 0.20 | Cpu (23) |
| 53 | HASH JOIN | | 2M | 2M | 853 | +31 | 16 | 43M | | | | | 83MB | . | 0.03 | Cpu (3) |
| 54 | BUFFER SORT | | | | 1 | +31 | 16 | 18400 | | | | | 896KB | . | | |
| 55 | PX RECEIVE | | 1150 | 9 | 1 | +31 | 16 | 18400 | | | | | . | . | | |
| 56 | PX SEND BROADCAST | :TQ10000 | 1150 | 9 | 1 | +36 | 1 | 18400 | | | | | . | . | | |
| 57 | VIEW | index$_join$_012 | 1150 | 9 | 1 | +36 | 1 | 1150 | | | | | . | . | | |
| 58 | HASH JOIN | | | | 1 | +36 | 1 | 1150 | | | | | 5MB | . | | |
| 59 | INDEX STORAGE FAST FULL SCAN | DCT_PK | 1150 | 5 | 1 | +36 | 1 | 1150 | 8 | 520KB | | | . | . | | |
| 60 | INDEX STORAGE FAST FULL SCAN | DCT_UK | 1150 | 6 | 1 | +36 | 1 | 1150 | 13 | 752KB | | | . | . | | |
| 61 | HASH JOIN | | 2M | 2M | 853 | +31 | 16 | 43M | | | | | 59MB | . | 0.03 | Cpu (3) |
| 62 | BUFFER SORT | | | | 1 | +31 | 16 | 144 | | | | | 32768 | . | | |
| 63 | PX RECEIVE | | 9 | 2 | 1 | +31 | 16 | 144 | | | | | . | . | | |
| 64 | PX SEND BROADCAST | :TQ10001 | 9 | 2 | 1 | +36 | 1 | 144 | | | | | . | . | | |
| 65 | VIEW | index$_join$_014 | 9 | 2 | 1 | +36 | 1 | 9 | | | | | . | . | | |
| 66 | HASH JOIN | | | | 1 | +36 | 1 | 9 | | | | | 4MB | . | | |
| 67 | INDEX STORAGE FAST FULL SCAN | DRT_PK | 9 | 1 | 1 | +36 | 1 | 9 | 1 | 8192 | | | . | . | | |
| 68 | INDEX STORAGE FAST FULL SCAN | DRT_UK | 9 | 1 | 1 | +36 | 1 | 9 | 2 | 16384 | | | . | . | | |
| 69 | HASH JOIN | | 2M | 2M | 853 | +31 | 16 | 43M | | | | | 34MB | . | 0.04 | Cpu (5) |
| 70 | BUFFER SORT | | | | 1 | +31 | 16 | 32 | | | | | 32768 | . | | |
| 71 | PX RECEIVE | | 2 | 1 | 1 | +31 | 16 | 32 | | | | | . | . | | |
| 72 | PX SEND BROADCAST | :TQ10002 | 2 | 1 | 1 | +36 | 1 | 32 | | | | | . | . | | |
| 73 | VIEW | index$_join$_010 | 2 | 1 | 1 | +36 | 1 | 2 | | | | | . | . | | |
| 74 | HASH JOIN | | | | 1 | +36 | 1 | 2 | | | | | 2MB | . | | |
| 75 | INLIST ITERATOR | | | | 1 | +36 | 1 | 2 | | | | | . | . | | |
| 76 | INDEX UNIQUE SCAN | DA_UK | 2 | | 1 | +36 | 2 | 2 | 1 | 8192 | | | . | . | | |
| 77 | INDEX STORAGE FAST FULL SCAN | DA_PK | 2 | 1 | 1 | +36 | 1 | 10 | 1 | 8192 | | | . | . | | |
| 78 | PX PARTITION HASH ALL | | 9M | 2M | 713 | +171 | 16 | 53M | | | | | . | . | | |
| 79 | TABLE ACCESS STORAGE FULL | T | 9M | 2M | 854 | +30 | 2048 | 53M | 917K | 887GB | | | 112MB | . | 87.53 | Cpu (9743) |
| | | | | | | | | | | | | | | | | cell smart table scan (138) |
| 80 | BUFFER SORT | | | | 23 | +813 | 16 | 20M | | | | | 1GB | . | 0.11 | Cpu (12) |
| 81 | PX RECEIVE | | 57M | 281K | 23 | +813 | 16 | 20M | | | | | . | . | 0.01 | Cpu (1) |
| 82 | PX SEND HASH | :TQ10004 | 57M | 281K | 70 | +812 | 1 | 20M | | | | | . | . | 0.02 | Cpu (2) |
| 83 | PARTITION LIST ALL | | 57M | 281K | 70 | +812 | 1 | 20M | | | | | . | . | | |
| 84 | TABLE ACCESS STORAGE FULL | TP_RT | 57M | 281K | 70 | +812 | 3 | 20M | 3009 | 3GB | | | 7MB | . | 0.18 | Cpu (19) |
| | | | | | | | | | | | | | | | | cell smart table scan (1) |
| 85 | PARTITION LIST ITERATOR | | 3 | 3 | 51 | +835 | 43M | 41M | | | | | . | . | 0.45 | Cpu (51) |
| 86 | PARTITION HASH ITERATOR | | 3 | 3 | 51 | +835 | 43M | 41M | | | | | . | . | 0.37 | Cpu (42) |
| 87 | INDEX RANGE SCAN | TX_PN_PK | 3 | 3 | 51 | +835 | 43M | 41M | 179K | 1GB | | | . | . | 4.82 | gc cr grant 2-way (8) |
| | | | | | | | | | | | | | | | | Cpu (459) |
| | | | | | | | | | | | | | | | | cell single block physical read: flash cache (77) |
===================================================================================================================================================================================================================================================================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment