How to find what options are available/installed?

— 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s