Oracle database detailed view

Users

The Users tab shows a list of the database users.

Options used

The Options used tab shows a list of Oracle options, presented with name, owner, and if the option is installed, and used.

Information on option usage along with the owner information is important from a license point of view since there is a fee for most used options.

The information is collected by the Oracle Management Option inventory scan, which is based on the Oracle LMS (License Management Services) scripts and follows the LMS guidelines, thus ensuring full Oracle compatibility.

An option is marked as used or not, based on the results of a number of queries. To see details, expand the option row by selecting the arrow to the left of the option name in the list. The queries are gathered in groups. Expand each group to see the included queries, the resulting values, and whether each query is triggered or not. All queries within a group must be triggered for the group to be triggered. At least one group must be triggered for the option to be marked as used.

It is possible to manually change the values in the Installed and Used columns. This can be relevant when the results from the Snow Inventory Oracle Scanner need to be adjusted. The manually changed values will be displayed in reports.

To manually change the values, select Edit database in the upper right area of the Oracle database detail view, and, on the Options view, select or clear the Installed and Used check boxes for one or more options.

When one or more values for an option have been manually changed, this is indicated in the Changes column. A manually changed value can be reverted to the original value.

Management packs agreed

The Management packs agreed tab shows a list of granted Oracle Management packs, presented by name, if it is agreed, by whom, and when.

The information is collected by the Oracle Management Option inventory scan, which is based on the Oracle LMS (License Management Services) scripts and follows the LMS guidelines, thus ensuring full Oracle compatibility.

It is possible to change the values in the Granted and Agreed columns manually. This can be useful when the results from the Snow Inventory Oracle Scanner need to be adjusted. The manually changed values will be displayed in reports.

To manually change the values, select Edit database in the upper right area of the Oracle database detail view, and, on the Management packs view, select or clear the Granted and Agreed check boxes for one or more management packs.

When one or more values for a management pack have been manually changed, this is indicated in the Changes column. A manually changed value can be reverted to the original value.

Feature usage

The Feature usage tab shows usage information.

The Oracle Management Option inventory scan collects the information when available. The more recent the Oracle version, the more feature usage information is available.