How to find list of installed features of Oracle Database?

Following are the two ways to know which options are installed on your oracle database:-

1. V$OPTION:- displays database options and features

select parameter from v$option where value='TRUE' order by parameter;

Expected output:-

2. DBA_REGISTRY:- displays information about the components installed with database.

select comp_name,version from dba_registry where status='VALID';

Values under status column may be one of the following: