Skip to content

Instantly share code, notes, and snippets.

@oracle9999

oracle9999/gist:b991022f72cd9fdd5776f797a187f7c1 Secret

Last active June 1, 2023 21:13
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 oracle9999/b991022f72cd9fdd5776f797a187f7c1 to your computer and use it in GitHub Desktop.
Save oracle9999/b991022f72cd9fdd5776f797a187f7c1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT FG.FID, FG.DCD, FG.MDT,1.00 ,
SUM (FG.N_CD), SUM (FG.d_nsd),SUM (FG.col3), SUM (FG.col3), SUM (FG.col3), SUM (FG.col3), SUM (FG.col3), SUM (FG.col3), SUM (FG.col3),SUM (FG.col3), SUM (FG.col3),
SUM (FG.col3),SUM (FG.col3)
FROM F_GTT FG
WHERE FG.FID = XXX
GROUP BY FG.FID, FG.DCD, FG.MDT
ORDER BY 1, 3
Global Information
------------------------------
Status : DONE (ALL ROWS)
Instance ID : 3
SQL ID : gmm2v6dtvu0yb
SQL Execution ID : 50331648
Execution Started : 06/01/2023 14:52:21
First Refresh Time : 06/01/2023 14:52:25
Last Refresh Time : 06/01/2023 14:53:11
Duration : 50s
Fetch Calls : 1
Global Stats
==================================================================================================================================================
| Elapsed | Cpu | IO | Application | Cluster | Other | Fetch | Buffer | Read | Read | Uncompressed | Offload | Offload |
| Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | Bytes | Elig Bytes | Returned Bytes |
==================================================================================================================================================
| 50 | 48 | 0.68 | 0.01 | 0.00 | 0.72 | 1 | 3M | 45632 | 22GB | 22GB | 22GB | 22GB |
==================================================================================================================================================
SQL Plan Monitoring Details (Plan Hash Value=3209725901)
==============================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Mem | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (Max) | (%) | (# samples) |
==============================================================================================================================================================================
| 0 | SELECT STATEMENT | | | | 47 | +4 | 1 | 31 | | | . | | |
| 1 | SORT GROUP BY | | 217 | 792K | 47 | +4 | 1 | 31 | | | 14336 | | |
| 2 | TABLE ACCESS STORAGE FULL | F_GTT | 63836 | 792K | 50 | +1 | 1 | 37491 | 45632 | 22GB | 14MB | 97.96 | Cpu (46) |
| | | | | | | | | | | | | | cell smart table scan (2) |
==============================================================================================================================================================================
Predicate Information (identified by operation id):
---------------------------------------------------
2 - storage("FG"."FID"=XXX)
filter("FG"."FID"=XXX)
SELECT DISTINCT ft.fT_NM, FGTT.DCD, ft.COl5, ft.FT_CID, RGTT.mcg_ind, C.D_CD
FROM rt_gtt RGTT,
F_GTT FGTT,
RD_FTIN ft,
RDC c
WHERE FGTT.eid = RGTT.nid
AND FGTT.etyp = RGTT.nety
AND FGTT.FID = ft.ftid
AND FGTT.FID = XXX
AND FGTT.DCD = c.DCD
AND ft.FT_CID = RGTT.mcid
ORDER BY ft.fT_NM, DCD
Global Information
------------------------------
Status : DONE (ALL ROWS)
Instance ID : 3
SQL ID : c3y3n73an8b69
SQL Execution ID : 50331648
Execution Started : 06/01/2023 14:54:39
First Refresh Time : 06/01/2023 14:54:43
Last Refresh Time : 06/01/2023 14:55:17
Duration : 38s
Fetch Calls : 1
Global Stats
==================================================================================================================================================
| Elapsed | Cpu | IO | Application | Cluster | Other | Fetch | Buffer | Read | Read | Uncompressed | Offload | Offload |
| Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | Bytes | Elig Bytes | Returned Bytes |
==================================================================================================================================================
| 39 | 37 | 0.57 | 0.01 | 0.00 | 0.59 | 1 | 4M | 45640 | 22GB | 22GB | 22GB | 22GB |
==================================================================================================================================================
SQL Plan Monitoring Details (Plan Hash Value=891026795)
========================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Mem | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (Max) | (%) | (# samples) |
========================================================================================================================================================================================
| 0 | SELECT STATEMENT | | | | 1 | +38 | 1 | 1 | | | . | | |
| 1 | SORT UNIQUE | | 19196 | 6M | 1 | +38 | 1 | 1 | | | 2048 | | |
| 2 | NESTED LOOPS | | | | 1 | +38 | 1 | 380 | | | . | | |
| 3 | NESTED LOOPS | | 19196 | 6M | 1 | +38 | 1 | 380 | | | . | | |
| 4 | NESTED LOOPS | | 94 | 6M | 1 | +38 | 1 | 2 | | | . | | |
| 5 | NESTED LOOPS | | 1M | 4M | 1 | +38 | 1 | 2 | | | . | | |
| 6 | VIEW | VW_DTP_E7E675E0 | 3M | 815K | 1 | +38 | 1 | 2 | | | . | | |
| 7 | HASH UNIQUE | | 3M | 815K | 35 | +4 | 1 | 2 | | | 11MB | | |
| 8 | TABLE ACCESS STORAGE FULL | F_GTT | 3M | 792K | 39 | +0 | 1 | 27239 | 45638 | 22GB | 14MB | 100.00 | Cpu (38) |
| 9 | TABLE ACCESS BY INDEX ROWID | rt_gtt | 1 | 2 | 1 | +38 | 2 | 2 | | | . | | |
| 10 | INDEX RANGE SCAN | rt_gtt_IX5 | 1 | 1 | 1 | +38 | 2 | 2 | | | . | | |
| 11 | TABLE ACCESS BY INDEX ROWID | RD_FTIN | 1 | 3 | 1 | +38 | 2 | 2 | | | . | | |
| 12 | INDEX RANGE SCAN | RD_FTIN_IX1 | 1 | 2 | 1 | +38 | 2 | 2 | | | . | | |
| 13 | INDEX RANGE SCAN | RDC_IX1 | 206 | 1 | 1 | +38 | 2 | 380 | 2 | 16384 | . | | |
| 14 | TABLE ACCESS BY INDEX ROWID | RDC | 204 | 169 | 1 | +38 | 380 | 380 | | | . | | |
========================================================================================================================================================================================
Predicate Information (identified by operation id):
---------------------------------------------------
8 - storage("FGTT"."FID"=XXX)
filter("FGTT"."FID"=XXX)
9 - filter("ITEM_3"="RGTT"."nety")
10 - access("ITEM_4"="RGTT"."nid")
11 - filter("FT"."FT_CID"="RGTT"."mcid")
12 - access("ITEM_2"="FT"."ftid")
13 - access("ITEM_1"="C"."DCD")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment