Skip to content

Instantly share code, notes, and snippets.

@oracle9999

oracle9999/gist:751bb4eb74501b87b99b1970bba2175f Secret

Last active June 2, 2023 20:22
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/751bb4eb74501b87b99b1970bba2175f to your computer and use it in GitHub Desktop.
Save oracle9999/751bb4eb74501b87b99b1970bba2175f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Global Information
------------------------------
Status : DONE (ALL ROWS)
Instance ID : 3
SQL ID : 00x97dww4wghf
SQL Execution ID : 50331648
Execution Started : 06/01/2023 14:25:51
First Refresh Time : 06/01/2023 14:25:55
Last Refresh Time : 06/01/2023 14:26:39
Duration : 48s
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 |
==================================================================================================================================================
| 48 | 47 | 0.57 | 0.01 | 0.00 | 0.26 | 1 | 3M | 45620 | 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 | | | | 45 | +4 | 1 | 31 | | | . | | |
| 1 | SORT GROUP BY | | 217 | 792K | 45 | +4 | 1 | 31 | | | 14336 | | |
| 2 | TABLE ACCESS STORAGE FULL | F_GTT | 101K | 792K | 49 | +0 | 1 | 82015 | 45620 | 22GB | 14MB | | |
====================================================================================================================================================================
Global Information
------------------------------
Status : DONE (ALL ROWS)
Instance ID : 2
SQL ID : c3f07s1a2u8qb
SQL Execution ID : 33554432
Execution Started : 04/24/2023 02:37:33
First Refresh Time : 04/24/2023 02:37:37
Last Refresh Time : 04/24/2023 02:37:37
Duration : 4s
Fetch Calls : 1
Global Stats
============================================================================================================================================================
| Elapsed | Cpu | IO | Application | Cluster | Other | Fetch | Buffer | Read | Read | Uncompressed | Offload | Offload | Cell |
| Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | Bytes | Elig Bytes | Returned Bytes | Offload |
============================================================================================================================================================
| 3.92 | 3.74 | 0.10 | 0.03 | 0.00 | 0.05 | 1 | 2M | 17355 | 17GB | 17GB | 17GB | 275MB | 98.41% |
============================================================================================================================================================
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 | | | | 1 | +4 | 1 | 23 | | | . | | |
| 1 | SORT GROUP BY | | 161 | 601K | 3 | +2 | 1 | 23 | | | 10240 | | |
| 2 | TABLE ACCESS STORAGE FULL | F_GTT | 7M | 601K | 5 | +1 | 1 | 7M | 17355 | 17GB | 14MB | | |
====================================================================================================================================================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment