Oracle database detail view

To view detailed information for a specific database:

  1. On the Oracle overview, and on the Products tab, select the applicable Oracle database edition, and then select Databases.

    The Database editions detail view appears.

  2. Click the specific database row.

    The Oracle database detail view appears.

The Oracle database detail view shows detailed information on an inventoried database according to the following table. The left area shows information about the server that the database is installed on. The information is based on data supplied by the Oracle Management Option inventory scan.

To edit information about the database, select Edit databases in the upper right area of the Oracle database detail view.

To navigate back to the Database editions detail view or the Oracle overview, click the links in the breadcrumb at the top of the page.

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 if the Management pack is agreed 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 User column shows the username of that user.

  • 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 manually change the values in the Granted and Agreed 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 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 information on usage.

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

Note

Feature usage information can be used as guidance, but it is not valid as 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.