V$OPTION

This view lists database options and features. Typically, although not always, options must be separately purchased and installed, whereas features come with the product and are enabled based on the product that is running (Standard Edition, Enterprise Edition, or Personal Oracle). If you want to see a list of all installed options for the database, use the DBA_REGISTRY view. See "DBA_REGISTRY".

Column Datatype Description
PARAMETER VARCHAR2(64) Name of the option (or feature)
VALUE VARCHAR2(64) TRUE if the option (or feature) is installed