Display all 12c new features installed

Question: What do I do to see all of the 12c new features that I have on my instance?

Answer:  To see the 12c new features, run this script:

prompt
prompt ********************************************************
prompt 12c features start here
prompt ********************************************************
prompt

-- **********************************************
-- Detect 12c Exadata Zone Maps
-- ********************************************** 

col c1 heading '12c Exadata|Zone|Maps used?' format a20

select 
   decode(count(*), 0, 'No', 'Yes') c1
from
   dba_zonemap_measures;

prompt
-- **********************************************
-- Detect 12c Adaptive SQL Execution Plans
-- ********************************************** 

col c1 heading '12c Adaptive |SQL Execution |Plans used?' format a20

select 
   decode(count(*), 0, 'No', 'Yes') c1
from
   v$parameter
where
   name ='optimizer_adaptive_reporting_only'
and
   value = 'FALSE';

prompt
-- **********************************************
-- Detect 12c Advanced Index Compression Used
-- ********************************************** 

col c1 heading '12c Advanced|Index Compression|used?' format a20

select
   decode(count(*), 0, 'No', 'Yes') c1
from
   dba_indexes
where
   compression like 'ADVANCED%';

-- ********************************************************
-- 12c using heat maps
-- ********************************************************

col c1 heading 'Using|Heat|maps?' format a20

select 
   decode(count(*), 0, 'No', 'Yes') c1
from
  dba_heat_map_segment;

prompt
-- **********************************************
-- Detect 12c sharded queues
-- ********************************************** 

col c1 heading '12c sharded|queues used?' format a20

select 
   decode(count(*), 0, 'No', 'Yes')  c1
from 
   dba_queues
where 
   sharded = 'TRUE';

set feedback on

-- *******************************************
-- Detect 12c multitenant (12c only)
-- ******************************************* 

set feedback off

col c1 heading 'Oracle Multitenant|used?' format a20

select 
   decode(count(*), 0, 'No', 'Yes') c1
from
  v$pdbs;

prompt
-- **********************************************
-- Detect 12c Exadata in-memory features
-- ********************************************** 

col c1 heading '12c Exadata|in-memory used?' format a20

select 
   decode(count(*), 0, 'No', 'Yes') c1
from
   dba_tables
where
   inmemory <> 'DISABLED';

prompt
-- **********************************************
-- Detect 12c SQL Plan management
-- ********************************************** 

col c1 heading 'SQL Plan|management|used?' format a20

select 
   decode(count(*), 0, 'No', 'Yes') c1
from   
    dba_sql_plan_baselines;

-- *******************************************
-- Is 12c Instance caging used?
-- ******************************************* 

col c1 heading '12c Instance Caging|Used?' format a20

select
   decode(count(*), 0, 'No', 'Yes') c1
from
   v$rsrcmgrmetric_history
order by
   begin_time;

 

---

Oracle Training from Don Burleson  The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!

Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:   and include the URL for the page.                      Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services   Copyright © 1996 -  2020 All rights reserved by Burleson Oracle ® is the registered trademark of Oracle Corporation.