Skip to content

Instantly share code, notes, and snippets.

@oracle9999

oracle9999/gist:d4ffa07a4f499e1114feba55a4417aa9 Secret

Last active January 24, 2023 04:30
Show Gist options
  • Save oracle9999/d4ffa07a4f499e1114feba55a4417aa9 to your computer and use it in GitHub Desktop.
Save oracle9999/d4ffa07a4f499e1114feba55a4417aa9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
******** Inline query ***************
SQL Text
------------------------------
SELECT RAWTOHEX ( STANDARD_HASH ( TO_CHAR ( TRIM (TRAN_TAB.LN4)), 'SHA512')) AS COL1_SHA_512
FROM TRAN_TAB
WHERE TRAN_TAB.PD_CD(+) = 'XXX'
AND TRAN_TAB.PART_DT = to_date(:B1,'DD-MON-YYYY HH24:MI:SS')
AND TRAN_TAB.dt_cr between to_date(:B2,'DD-MON-YYYY HH24:MI:SS') and to_date(:B3,'DD-MON-YYYY HH24:MI:SS')
Global Information
------------------------------
Status : DONE (ALL ROWS)
Instance ID : 4
SQL Execution ID : 67108864
Execution Started : 01/23/2023 22:53:11
First Refresh Time : 01/23/2023 22:53:11
Last Refresh Time : 01/23/2023 22:53:52
Duration : 41s
Module/Action : SQL*Plus/-
Program : sqlplus.exe
Fetch Calls : 2335
Binds
========================================================================================================================
| Name | Position | Type | Value |
========================================================================================================================
| :B1 | 1 | VARCHAR2(16386) | 22-jan-2023 00:00:00 |
| :B2 | 2 | VARCHAR2(16386) | 22-jan-2023 00:00:00 |
| :B3 | 3 | VARCHAR2(16386) | 22-Jan-2023 05:00:00 |
========================================================================================================================
Global Stats
=========================================================================================================================================================================
| Elapsed | Cpu | IO | Application | Concurrency | Cluster | Other | Fetch | Buffer | Read | Read | Uncompressed | Offload | Offload | Cell |
| Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | Bytes | Elig Bytes | Returned Bytes | Offload |
=========================================================================================================================================================================
| 35 | 28 | 5.33 | 0.00 | 0.00 | 0.00 | 1.16 | 2335 | 20M | 160K | 156GB | 156GB | 156GB | 350MB | 99.78% |
=========================================================================================================================================================================
SQL Plan Monitoring Details (Plan Hash Value=3658259691)
===========================================================================================================================================================================================
| 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 | | | | 38 | +0 | 1 | 12M | | | . | 74.29 | Cpu (25) |
| | | | | | | | | | | | | | SQL*Net more data to client (1) |
| 1 | FILTER | | | | 38 | +0 | 1 | 12M | | | . | | |
| 2 | PARTITION RANGE SINGLE | | 12M | 4M | 38 | +0 | 1 | 12M | | | . | | |
| 3 | TABLE ACCESS STORAGE FULL | TRAN_TAB | 12M | 4M | 41 | +0 | 1 | 12M | 160K | 156GB | 7MB | 25.71 | Cpu (5) |
| | | | | | | | | | | | | | cell smart table scan (4) |
===========================================================================================================================================================================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment