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;