Oracle Database Blog‎ > ‎Info pages‎ > ‎

Which components and options are installed on Oracle Database

You can get this information from:
-- List of components and statuses
select * from DBA_REGISTRY;

-- You get the list of options with TRUE/FALSE indicator
select * from v$option;