Skip to main content

Oracle database detailed view

The Oracle database detailed view shows detailed information on an inventoried database. You can reach the page from the Oracle overview > Products tab by selecting the applicable Oracle Database edition, selecting Go to, and then selecting the specific database row.

The left area of the view shows information about the server that the database is installed on. The database information is presented on tabs as described in the table below. The information is based on data supplied by the Oracle Management Option inventory scan.

To edit information about the database, select Edit database in the upper-right corner.

Tab

Description

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.

  • Agreed column: The information is important from a license point of view since there is a fee for most agreed Management packs. If usage of the Management pack is agreed by a user, the username is shown in the User column.

  • User column: The Oracle Management Option also detects usage of features that requires a Management Pack to be licensed. These will be illustrated by the User column containing one of the following:

    • ACCEPTED BY DATABASE SETTING

    • ACCEPTED BY USAGE OF SQL PROFILES

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.

Note

Feature usage information can be used as guidance, but it is not valid as a basis for licensing requirements. Instead, use the information in the Options and Management packs tabs.

Instances

The Instances tab shows all installed instances that are using this database.