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.

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:

Attribute	Description
name	Name of the option
instance	Name of the option
type	Type of the option
version	Database version
used	Overall option usage
features	Features included in the option

Example of Feature Attributes

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

Attribute	Description
name	Name of the feature
version	Database version
type	Type of the feature
currently_used	Indicates if the feature in question was used during the last sampling interval prompt or was used at the refresh moment
dbid	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.

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.