Which components and options are installed on Oracle Database

<<Back to DB Administration Main Page

Find out Which Database Components and Options are Installed on Oracle Database

List Components and status

col COMP_ID for a10      
col COMP_NAME for a40
col VERSION  for a15    
col STATUS   for a5    
col MODIFIED for a30    
col CONTROL     for a5    
col SCHEMA      for a15    

select COMP_ID,
COMP_NAME,
VERSION,
STATUS,
MODIFIED,
CONTROL,  
SCHEMA
from DBA_REGISTRY;

List down the Options

Value=>TRUE=Installed and FALSE=Not Installed

col PARAMETER for a40
col VALUE for a30

select * from v$option

Features Used on Oracle Database

SET LINESIZE 180;
SET PAGESIZE 1000;
SET FEEDBACK OFF;
set heading ON
col Name for a60
select version, name, detected_usages, currently_used, first_usage_date, last_usage_date
from DBA_FEATURE_USAGE_STATISTICS
where detected_usages > 0
order by 1, 2
/