******************** UPDATE ***************** ---------- NON TDE---------------- SQL Monitoring Report SQL Text ------------------------------ update /*+ monitor */ USER_NONTDE.PBR set RL_OID='XXX' where RL_OID='SYSTEM' Global Information ------------------------------ Status : DONE Instance ID : 2 SQL ID : 4qtkr8gsd38yz SQL Execution ID : 33554432 Execution Started : 07/19/2021 05:54:02 First Refresh Time : 07/19/2021 05:54:02 Last Refresh Time : 07/19/2021 05:56:16 Duration : 134s Module/Action : TOAD 12.7.0.121/- Program : Toad.exe Global Stats ====================================================================== | Elapsed | Cpu | IO | Concurrency | Buffer | Read | Read | | Time(s) | Time(s) | Waits(s) | Waits(s) | Gets | Reqs | Bytes | ====================================================================== | 146 | 34 | 112 | 0.00 | 2M | 219K | 13GB | ====================================================================== SQL Plan Monitoring Details (Plan Hash Value=4200455362) =========================================================================================================================================================== | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (%) | (# samples) | =========================================================================================================================================================== | 0 | UPDATE STATEMENT | | | | 1 | +2 | 1 | 0 | | | | | | 1 | UPDATE | PBR | | | 2 | +1 | 1 | 0 | 48 | 384KB | | | | 2 | OPTIMIZER STATISTICS GATHERING | | 49974 | 477K | 1 | +2 | 1 | 28710 | | | | | | 3 | TABLE ACCESS STORAGE FULL | PBR | 49974 | 477K | 134 | +2 | 1 | 28710 | 219K | 13GB | | | =========================================================================================================================================================== ---------- TDE---------------- SQL Monitoring Report SQL Text ------------------------------ update /*+ monitor */ USER_TDE.PBR set RL_OID='XXX' where RL_OID='SYSTEM' Global Information ------------------------------ Status : DONE Instance ID : 2 SQL ID : c0jxk30g2f83x SQL Execution ID : 33554432 Execution Started : 07/19/2021 05:43:20 First Refresh Time : 07/19/2021 05:43:20 Last Refresh Time : 07/19/2021 05:46:17 Duration : 177s Module/Action : TOAD 12.7.0.121/- Program : Toad.exe Global Stats ============================================================================= | Elapsed | Cpu | IO | Cluster | PL/SQL | Buffer | Read | Read | | Time(s) | Time(s) | Waits(s) | Waits(s) | Time(s) | Gets | Reqs | Bytes | ============================================================================= | 189 | 67 | 122 | 0.42 | 0.59 | 2M | 220K | 13GB | ============================================================================= SQL Plan Monitoring Details (Plan Hash Value=4200455362) =========================================================================================================================================================== | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (%) | (# samples) | =========================================================================================================================================================== | 0 | UPDATE STATEMENT | | | | 5 | +2 | 1 | 0 | | | | | | 1 | UPDATE | PBR | | | 6 | +1 | 1 | 0 | 62 | 496KB | | | | 2 | OPTIMIZER STATISTICS GATHERING | | 8863 | 479K | 5 | +2 | 1 | 28710 | | | | | | 3 | TABLE ACCESS STORAGE FULL | PBR | 8863 | 479K | 177 | +2 | 1 | 28710 | 220K | 13GB | | | =========================================================================================================================================================== ************************* INSERT*************************** --------------NON TDE------------------------------ SQL Text ------------------------------ insert /*+ monitor */ into USER_NONTDE.PADT select * from USER_TDE.PADT where rownum < 100001 Global Information ------------------------------ Status : DONE Instance ID : 2 SQL ID : d2zj2arpj3jku SQL Execution ID : 33554435 Execution Started : 07/19/2021 06:21:32 First Refresh Time : 07/19/2021 06:21:32 Last Refresh Time : 07/19/2021 06:21:49 Duration : 17s Module/Action : TOAD 12.7.0.121/- Program : Toad.exe Global Stats ========================================================================================================================================= | Elapsed | Cpu | IO | Application | Cluster | Buffer | Read | Read | Uncompressed | Offload | Offload | Cell | | Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Gets | Reqs | Bytes | Bytes | Elig Bytes | Returned Bytes | Offload | ========================================================================================================================================= | 19 | 6.06 | 12 | 0.00 | 0.10 | 327K | 34529 | 282MB | 11MB | 14MB | 12MB | 9.36% | ========================================================================================================================================= SQL Plan Monitoring Details (Plan Hash Value=1401731568) ================================================================================================================================================================== | 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 | INSERT STATEMENT | | | | 16 | +2 | 1 | 0 | | | . | | | | 1 | LOAD TABLE CONVENTIONAL | PADT | | | 16 | +2 | 1 | 0 | 34305 | 268MB | . | | | | 2 | OPTIMIZER STATISTICS GATHERING | | 66M | 252K | 16 | +2 | 1 | 100K | | | . | | | | 3 | COUNT STOPKEY | | | | 16 | +2 | 1 | 100K | | | . | | | | 4 | TABLE ACCESS STORAGE FULL | PADT | 66M | 252K | 16 | +2 | 1 | 100K | 224 | 14MB | 7MB | | | ================================================================================================================================================================== ------------------TDE----------------------------- SQL Monitoring Report SQL Text ------------------------------ insert /*+ monitor */ into USER_TDE.PADT_OR select * from USER_TDE.PADT where rownum < 100001 Global Information ------------------------------ Status : DONE Instance ID : 2 SQL Execution ID : 33554435 Execution Started : 07/19/2021 06:20:59 First Refresh Time : 07/19/2021 06:20:59 Last Refresh Time : 07/19/2021 06:21:20 Duration : 21s Module/Action : TOAD 12.7.0.121/- Program : Toad.exe Global Stats ========================================================================================================================================= | Elapsed | Cpu | IO | Application | Cluster | Buffer | Read | Read | Uncompressed | Offload | Offload | Cell | | Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Gets | Reqs | Bytes | Bytes | Elig Bytes | Returned Bytes | Offload | ========================================================================================================================================= | 23 | 8.39 | 15 | 0.00 | 0.00 | 356K | 37868 | 310MB | 11MB | 16MB | 14MB | 9.38% | ========================================================================================================================================= SQL Plan Monitoring Details (Plan Hash Value=1401731568) ====================================================================================================================================================================== | 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 | INSERT STATEMENT | | | | 20 | +2 | 1 | 0 | | | . | | | | 1 | LOAD TABLE CONVENTIONAL | PADT_OR | | | 21 | +1 | 1 | 0 | 37604 | 294MB | . | | | | 2 | OPTIMIZER STATISTICS GATHERING | | 66M | 252K | 20 | +2 | 1 | 100K | | | . | | | | 3 | COUNT STOPKEY | | | | 20 | +2 | 1 | 100K | | | . | | | | 4 | TABLE ACCESS STORAGE FULL | PADT | 66M | 252K | 20 | +2 | 1 | 100K | 264 | 16MB | 7MB | | | ====================================================================================================================================================================== **************************** SELECT**************************** ---------------NON TDE---------------------------- SQL Monitoring Report SQL Text ------------------------------ select /*+ monitor */ /*nontde*/count(*) FROM USER_NONTDE.PRC_ADT F, USER_NONTDE.PRC_HST B WHERE F.CID = B.CID Global Information ------------------------------ Status : DONE (ALL ROWS) Instance ID : 1 SQL ID : 9pmtuv407bvd4 SQL Execution ID : 16777216 Execution Started : 07/20/2021 10:14:53 First Refresh Time : 07/20/2021 10:14:53 Last Refresh Time : 07/20/2021 10:14:55 Duration : 2s Module/Action : SQL*Plus/- Program : sqlplus.exe Fetch Calls : 1 Global Stats =========================================================================== | Elapsed | Cpu | IO | Cluster | Fetch | Buffer | Read | Read | | Time(s) | Time(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | =========================================================================== | 1.76 | 0.99 | 0.70 | 0.07 | 1 | 55285 | 1632 | 39MB | =========================================================================== SQL Plan Monitoring Details (Plan Hash Value=3387689024) ================================================================================================================================================================== | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (%) | (# samples) | ================================================================================================================================================================== | 0 | SELECT STATEMENT | | | | 1 | +2 | 1 | 1 | | | | | | 1 | SORT AGGREGATE | | 1 | | 1 | +2 | 1 | 1 | | | | | | 2 | NESTED LOOPS | | 5M | 1134 | 1 | +2 | 1 | 0 | | | | | | 3 | INDEX STORAGE FAST FULL SCAN | PC_HST1 | 2M | 1060 | 1 | +2 | 1 | 2M | 496 | 30MB | | | | 4 | INDEX RANGE SCAN | PC_ADT1 | 3 | 1 | 2 | +1 | 2M | 0 | 1136 | 9MB | | | ================================================================================================================================================================== ----------------------TDE------------------------------- SQL Monitoring Report SQL Text ------------------------------ select /*+ monitor */ /*tde*/count(*) FROM USER_TDE.PRC_ADT F, USER_TDE.PRC_HST B WHERE F.CID = B.CID Global Information ------------------------------ Status : DONE (ALL ROWS) Instance ID : 1 SQL ID : 1krju1dggunmb SQL Execution ID : 16777216 Execution Started : 07/20/2021 10:17:35 First Refresh Time : 07/20/2021 10:17:35 Last Refresh Time : 07/20/2021 10:17:38 Duration : 3s Module/Action : SQL*Plus/- Program : sqlplus.exe Fetch Calls : 1 Global Stats =========================================================================== | Elapsed | Cpu | IO | Cluster | Fetch | Buffer | Read | Read | | Time(s) | Time(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | =========================================================================== | 3.35 | 1.83 | 1.51 | 0.02 | 1 | 496K | 3705 | 57MB | =========================================================================== SQL Plan Monitoring Details (Plan Hash Value=3628189650) ================================================================================================================================================================= | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (%) | (# samples) | ================================================================================================================================================================= | 0 | SELECT STATEMENT | | | | 1 | +3 | 1 | 1 | | | | | | 1 | SORT AGGREGATE | | 1 | | 1 | +3 | 1 | 1 | | | | | | 2 | NESTED LOOPS | | 5M | 1191 | 2 | +2 | 1 | 0 | | | | | | 3 | INDEX STORAGE FAST FULL SCAN | PC_HST | 2M | 1117 | 2 | +2 | 1 | 2M | 542 | 33MB | | | | 4 | INDEX RANGE SCAN | PC_ADT | 3 | 1 | 3 | +2 | 2M | 0 | 3163 | 25MB | | | =================================================================================================================================================================