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 > 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.

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

Tab

Description

Users

The tab shows a list of the database users.

Options used

The 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.

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 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 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 tab shows a list of granted Oracle Management packs, presented by name, if it is agreed, by whom, and when.

  • 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 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 page 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 tab shows information on usage.

The information is collected and shown 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 tab shows all installed instances that are using this database.

In this section: