Check Installed Features And Options

To see a list of installed features and their status:

select *
from   dba_registry
order by comp_name
;

To see which options are available:

select * 
from   v$option
order by parameter
;