Oracle autonomous transaction processing - a good start

SQL> select patch_id,version,action_time,description,bundle_series from dba_registry_sqlpatch;
 
  PATCH_ID VERSION ACTION_TIME DESCRIPTION BUNDLE_SERIES 
 ---------------- -------------------- --------------------------- ---------------------------------------------------------------------------------------------------- ------------------------------
  27833146 12.2.0.1 18-04-15 22:53:33,631780000 ADW BUNDLE PATCH 180408.12.2.0.1. (27833146) 12.2.0.1.0ADW 
  27912909 12.2.0.1 18-05-13 09:26:55,583388000 ADW BUNDLE PATCH 180423.12.2.0.1 (27912909) 12.2.0.1.0ADW 
  28021834 12.2.0.1 18-05-20 06:30:40,791622000 ADW BUNDLE PATCH 180511.12.2.0.1 (28021834) 12.2.0.1.0ADW 
  28083996 12.2.0.1 18-06-10 13:24:07,039773000 ADW BUNDLE PATCH 180531.12.2.0.1 (28083996) 12.2.0.1.0ADW 
  28228725 12.2.0.1 18-07-01 16:20:00,784425000 ADW BUNDLE PATCH 180621.12.2.0.1 (28228725) 12.2.0.1.0ADW 
  28392695 12.2.0.1 18-07-29 09:01:06,437228000 ADW BUNDLE PATCH 12.2.0.1.0(ID:180722) 
 

orcl_high> show parameter _disable_cell_optimized_backups
 NAME TYPE VALUE 
 ------------------------------- ------- ----- 
 _disable_cell_optimized_backups boolean TRUE 
 orcl_high>
 

orcl_high> create table t1 as select * from (select rownum t1_id, object_id p1, object_name p2, owner p3 from all_objects),(select rownum from dual CONNECT BY LEVEL <=20000); Table T1 created. orcl_high> update t1 set t1_id = null where t1_id between 500 and 510;
 
 220,000 rows updated.
 
 orcl_high> commit;
 
 Commit complete.
 
 orcl_parallel> exec dbms_stats.gather_table_stats('ADMIN','t1');
 
 PL/SQL procedure successfully completed.
 
 orcl_high> select table_name, num_rows, sample_size, last_analyzed from user_tables where table_name like '%T1%'; 
 
 TABLE_NAME NUM_ROWS SAMPLE_SIZE LAST_ANA
 -------------------------------------------------------------------------------------------------------------------------------- ---------------- ---------------- --------
 T1 366240000 366240000 18-08-29
 
 orcl_high> select count(*) from t1 where t1_id is null;
 
  COUNT(*)
 ----------------
  220000
 
 orcl_high> select n.name,s.value from v$mystat s, v$statname n where n.statistic#=s.statistic# and n.name like '%cell flash cache read%';
 
 NAME VALUE
 ------------------------------------------------------------ ----------------
 cell flash cache read hits 17229
 cell flash cache read hits for controlfile reads 0
 cell flash cache read hits for smart IO 17159
 
 orcl_high> select n.name,s.value from v$mystat s, v$statname n where n.statistic#=s.statistic# and n.name like '%physical%optimized%';
 
 NAME VALUE
 ------------------------------------------------------------ ----------------
 physical read requests optimized 17229
 physical read total bytes optimized 17963958272
 ...
 orcl_high> select n.name,s.value from v$mystat s, v$statname n where n.statistic#=s.statistic# and n.name like '%smart scan%';
 
 NAME VALUE
 ------------------------------------------------------------ ----------------
 cell physical IO interconnect bytes returned by smart scan 18662816
 ...