Options Tab

The Options tab on the properties for an Oracle database instance displays a list of Oracle options installed on the database instance. Oracle options that are installed, but for which the Used column displays No, have no impact on Oracle licensing. The data showing which Oracle options are installed may come from either of two sources:

The FlexNet inventory gathered from this database instance itself
Inventory from an Oracle Enterprise Manager repository (the database instance used to store the OEM data) for the installation of Oracle Enterprise Manager that most recently claimed management knowledge of this database instance. In this case, the OEM repository is identified on the General tab of these properties, as Managing OEM.

This information comes from running a series of Oracle queries for each option against the database instance. If any one of the queries returns a non-zero value for Used, the option is listed as used on this tab, as required by Oracle. For example, queries testing for the Advanced Compression option include, among others:

AdvancedCompression_ByTableCompression
AdvancedCompression_BySecureFilesCompressionAndDeDuplication
AdvancedCompression_ByLogArchiveCompression
AdvancedCompression_ByFeatureDataGuard.

Tip: If the inventory source for this database instance is the FlexNet inventory agent locally installed on the Oracle server, then the tracker.log file shows the results for every query, allowing you to dig deeply into the evidence for use of each Oracle option. This includes queries for options that are not currently installed/available on this database instance, but are checked anyway. If this database instance happens to also be an OEM repository (storing management data for Oracle Enterprise Manager), the log is extended to show results for every query on every database instance on every Oracle server managed by that installation of OEM. The location of the log file on each Oracle server is:

On Windows: $(TempDirectory)\ManageSoft\tracker.log
On UNIX-like platforms: /var/opt/managesoft/log/tracker.log.

The full list of options that may be relevant to this database instance depends on both the version and the edition of Oracle Database for which this is a database instance. The options shown in this tab are definitely applicable to this database instance, and identified by the Oracle queries as described above. To identify others that are not installed/available on this database instance but could be relevant, please see the Oracle listings for your version and edition of Oracle Database. For example:

For Oracle Database 9i, see https://docs.oracle.com/cd/B10500_01/server.920/a96531/ch5_edit.htm
For Oracle Database 10g, see https://docs.oracle.com/cd/B19306_01/license.102/b14199/options.htm#DBLIC145, and for variations across database edition, also see https://docs.oracle.com/cd/B19306_01/license.102/b14199/editions.htm#BABJICBB
For Oracle Database 11g, see https://docs.oracle.com/cd/B28359_01/license.111/b28287/options.htm#DBLIC138, and across editions https://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm#DBLIC116
For Oracle Database 12c, see https://docs.oracle.com/database/121/DBLIC/editions.htm#DBLIC-GUID-B6113390-9586-46D7-9008-DCC9EDA45AB4.

Search for an Oracle option: This search is restricted to Oracle options that are installed on this database instance (whether used or not). For more information about using lists, filters, and other UI options, see the topics under Using Lists in FlexNet Manager Suite.
Open the properties for an Oracle option: You can click the linked Option name property, or select any installed Oracle option and click Open to view its properties. For more details on those option properties, see Application Properties.
Open the Usage Details for an Oracle option: You can click the linked Used property to view usage details as outlined below.

The following properties of Oracle options (listed alphabetically) are available for display. By default, all of these properties are displayed, although you may choose to hide some using the Choose columns dialog box.

Table 1. Oracle option properties on the Options tab
Property	Description
Enabled by	This column may show: `This instance` when the Oracle option was enabled locally on this Oracle database instance (described in this property sheet). `Oracle Enterprise Manager` when the Oracle option is being 'remotely' managed through Oracle Enterprise Manager (OEM). In this case, you can identify which implementation of OEM is controlling the option by switching to the General tab and checking the value for Managing OEM. The same implementation of OEM manages both the database instance and associated options (other than those options that were enabled locally on the database instance). Tip: This value (`Oracle Enterprise Manager`) can be displayed only after inventory has been received from the managing OEM. In the absence of that inventory (such as immediately after an upgrade of FlexNet Manager Suite), this column defaults to `This instance`. After the next full inventory import and compliance calculation (typically overnight, unless you run one sooner), the value is updated as required.
Option name	The name of the Oracle option installed on this instance. Click to view the properties for this Oracle option or pack. See General Tab.
Usage	Specifies how the usage of each Oracle option is determined for this Oracle instance. From the drop-down list in the Usage column for an installed option, select one of the following: `From inventory` — (default) Usage of this option is tracked by FlexNet Manager Suite through inventory. This requires that usage tracking has been configured in the Usage tab of the application properties for this option. (You can check by selecting the option from the list and clicking Open to navigate to its property sheet.) `Always used` — Choose this to specify that the option should always be counted as used on this instance. (If you choose this setting and save your changes, the Used column displays `Yes`.) `Never used` — Choose this only when you know that the option is never used on this instance. (If you choose this setting and save your changes, the Used column displays `No`.)
Used	Indicates if the Oracle option has been used on this database instance. Tip: This value is forced to `Yes` when the Usage column shows `Always used`; or forced to `No` when the Usage column shows `Never used`. If the Usage column is changed to `From inventory`, this Used column shows the value imported in the most recent inventory for this database instance. Click the `Yes` or `No` value to open the Usage Details dialog box, which displays the following details: Used — Displays the same `Yes` or `No` value, as documented above, that you clicked to open this dialog. Local server — The host name of the local server that was scanned to produce this result, and the scan date displays if the scan took place on your local server. This field only displays when one or more features are detected on a local server. OEM server(s) — The host names of all the Oracle Database servers that were reported by each scanned OEM server, and the date that each host was scanned. This field only displays when one or more OEM servers are in use. If data is available, the result of each query is listed with the results for any used options displaying at the top of the list. The information displays for each result: `Used` — Displays `Yes` if the imported inventory shows that the result of this query show a non-zero value which indicates that this feature is always used or is in use, or displays `No` if the query result returns a zero value which indicates it is never used or is not in use `Message` — A statement summarizing the inventory investigation that tested for usage, and whether the result was 'used' or 'not used' `Source` — Which feature of the Oracle database instance was tested to produce this result. One of following messages displays when data is not available: `Data is not available` — There is no data available which is relevant for reporting to Oracle LMS. `An error occurred while retrieving usage data` — FlexNet Manager Suite was unable to establish a connection. This may occur if, for example, access is incorrectly configured. In this case, there may be data in the service for an instance, but FlexNet Manager Suite is not able to access the data.