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:

• INVALID
• VALID
• LOADING
• LOADED
• UPGRADING
• UPGRADED
• DOWNGRADING
• DOWNGRADED
• REMOVING
• REMOVED

Expected output:-