Thanks for the question, Dusan.
Asked: October 27, 2016 - 10:36 am UTC
Last updated: October 27, 2016 - 3:47 pm UTC
Version: 12.1.0.2
Viewed 1000+ times
SQL> drop table t purge; Table dropped. SQL> create global temporary table t 2 on commit delete rows as 3 select * from all_objects where 1=0; Table created. SQL> SQL> alter system set temp_undo_enabled=false; System altered. SQL> SQL> set autotrace traceonly statistics; SQL> SQL> insert into t select * from all_objects; 90254 rows created. Statistics ---------------------------------------------------------- 1293 recursive calls 7835 db block gets 72364 consistent gets 2405 physical reads 567100 redo size 817 bytes sent via SQL*Net to client 1246 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 1547 sorts (memory) 0 sorts (disk) 90254 rows processed SQL> commit; Commit complete. SQL> alter system set temp_undo_enabled=true; System altered. SQL> SQL> insert into t select * from all_objects; 90254 rows created. Statistics ---------------------------------------------------------- 99 recursive calls 7804 db block gets 70979 consistent gets 2276 physical reads 565944 redo size 820 bytes sent via SQL*Net to client 1246 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 1504 sorts (memory) 0 sorts (disk) 90254 rows processed SQL> SQL> conn chris/****@pdb Connected. SP2-0158: unknown SET option "sqlformat" SQL> SQL> alter system set temp_undo_enabled=true; System altered. SQL> SQL> set autotrace traceonly statistics; SQL> SQL> insert into t select * from all_objects; 90254 rows created. Statistics ---------------------------------------------------------- 105 recursive calls 7816 db block gets 70983 consistent gets 2270 physical reads 272 redo size 812 bytes sent via SQL*Net to client 1246 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 1504 sorts (memory) 0 sorts (disk) 90254 rows processed
Dusan Valasek, October 28, 2016 - 8:33 am UTC
Need more information on Multitenant? Check out the Multitenant docs for the Oracle Database