— shows what options are enabled
SQL> select parameter FROM v$option where value = 'TRUE';

PARAMETER
—————————————————————-
Partitioning
Objects
Advanced replication
Bit-mapped indexes
…

— shows what options are disabled/not instaled
SQL> select parameter FROM v$option where value = 'FALSE';

PARAMETER
—————————————————————-
Real Application Clusters
Oracle Label Security
Data Mining Scoring Engine