Oracle Database Installed Options

Oracle Database Installed and Enabled Options through Query

The Oracle.OracleRDBMS_Extended pattern module executes an SQL query against the database, which returns a list of all Options and their Installed or Uninstalled status.

Related topics

Oracle Database

Oracle publisher

Oracle Database Information Open link

Default Installed Options 

The Installed Options searched for by default are as follows:

  • Active Data Guard
  • Advanced Analytics (>12c)
  • Advanced Compression
  • Advanced Replication
  • Advanced Security
  • Data Mining
  • Database Vault
  • Exadata
  • Label Security
  • Multitenant (>=12c)
  • OLAP
  • Oracle Active Data Guard or Real Application Clusters
  • Oracle Database In-Memory
  • Partitioning
  • Real Application Clusters
  • Real Application Cluster One Node
  • Real Application Testing
  • Spatial
  • Total Recall

Default Installed Packs

The Installed Packs searched for by default are as follows:

  • Change Management Pack
  • Configuration Management Pack for Oracle Database
  • Data Masking Pack
  • Diagnostic Pack
  • Provisioning and Patch Automation Pack
  • Provisioning and Patch Automation Pack for Database
  • Tuning Pack
  • WebLogic Server Management Pack Enterprise Edition

After the search is complete and all Installed Options and Packs are discovered, the pattern models a Detail Node for each Installed Option, and links it to the Oracle RDBMS Software Instance. Details for individual features (only if found through the extended SQL discovery) are linked to these Detail Nodes. The search results are displayed in tables that are visible directly from the Software Instance.

Example of Option Attributes

The following table describes the list of attributes reported for each Option:

nameName of the option
instanceName of the option
typeType of the option
versionDatabase version
usedOverall option usage
featuresFeatures included in the option

Example of Feature Attributes

The following table describes the list of attributes reported for each Feature:

nameName of the feature
versionDatabase version
typeType of the feature

Indicates if the feature in question was used during the last sampling interval

prompt or was used at the refresh moment


Internal unique identifier for an Oracle database

detected_usages  Number of detected usages
extra_feature_info Additional information related to the feature (for example, "encryption used: N times")
first_usage_date   First usage date
last_sample_date   Last sample date
last_usage_date    Last usage date
optionpackname     Name of the related option
total_samples      Number of times the system has woken up and checked for feature usage
usage              Represents overall usage

This information is extracted from the DBA_FEATURE_USAGE_STATISTICS view that is updated weekly, so generating a report about usage changes might take some time. Sometimes the usage data might indicate false positives caused by the inclusion of usage by sample schemas (such as HR, PM, SH, etc.), system or internal usage.

For more information about the reported attributes in the related SQL request, see Oracle Database Online Documentation Open link .

For Oracle Advanced Analytics, a check is performed to confirm the presence of Oracle R installed on the host and Oracle Data Mining. If none of them is found, the Detail Node is not created.

Oracle Database Installed Options through File

If the executed SQL query fails or is unable to be executed for any reason, the Oracle.OracleRDBMS_Extended pattern module attempts to get the Installed Options from the comps.xml file. The pattern models a Detail Node for each Installed Option and links it to the Oracle RDBMS Software Instance. 


When you discover Oracle Database Installed Options, the following issues might occur:


Cannot discover the Data Masking pack

Issue symptom: The Data Masking pack enabled through the Oracle Enterprise Manager is not found on the host.

Resolution: The Data Masking pack might be present as a detail on the Oracle EM SI.

The SQL query execution is suspended

Issue symptom: The SQL query hangs.

Resolution: To disable the query, use the sql_discovery configuration option that can control the query execution.

Was this page helpful? Yes No Submitting... Thank you