Skip to main content
Matrix42 Self-Service Help Center

Oracle Database Worksheet

  1. Last updated
  2. Save as PDF

Overview

The Oracle Database Worksheet presents the information about all your inventoried Oracle database instances. If you have Oracle databases deployed, you should use Matrix42 Oracle Database and Datacenter Compliance add-on to inventory all servers, both physical and virtual, as well as hypervisors. This will enable you to proactively assess license implications for the Oracle database products before any vendor review, mitigate your financial risks, and identify possible cost savings.

The Oracle Database Worksheet navigation item consists of four search pages that display collected data. Each search page provides a specific view on your data:

  • Systems: Operating system environments that host an Oracle database.
  • Instances: Oracle database instances and essential information on the relevant computer system.
  • Options: Oracle database options and essential information on the relevant computer system and instance.
  • Features: Oracle database features and essential information on the relevant computer system, instance, and option.

Systems

This navigation item contains all computer systems where the scan engine has identified an instance of an Oracle database. You can open and edit Oracle systems as computers. The minimum set of actions is also available.

The search page displays the most important data related to managing Oracle systems:

  • Computer: Unique name of the computer system.
  • Operating System: Name and version of operating system.
  • Status: Asset status of the computer.
  • Type: Operational type of the computer system, displaying either "Physical" or relevant virtualization technology (e.g., VMware, XEN, LPAR).
  • Partitioning: Segmenting type that is important for licensing purposes in case of virtualization (Soft Partitioning or Hard Partitioning).
  • vCenter: Name of the relevant vCenter environment in case of VMware virtualization.
  • Cluster: Name of the hardware cluster where the computer belongs to.
  • Host: Name of the physical computer system where the virtualised computer system is run.
  • Hardware Model: Brand and model of hardware of the physical computer or the relevant host for a virtual machine.
  • CPU Model: Brand and model of physical processor of the physical computer or the relevant host for a virtual machine.
  • CPU Speed (MHz): Clock speed of physical processor of the physical computer or the relevant host for a virtual machine.
  • Sockets: Number of processor sockets equipped with a CPU.
  • Cores: Total number of processor cores available on all sockets.
  • Threads: Total number of processor threads available on all cores.
  • Core Factor: Oracle Core Factor that applies to physical processor according to Oracle terms.
  • Core Value: Value that is calculated by multiplying number of cores by the relevant Core Factor.

Instances

This search page displays all Oracle database instances which the scan engine has identified on the scanned servers along with the essential information about the corresponding computer system. You can open Oracle instances for editing. However, most of the data is read-only.

The search page displays the most important data related to Oracle instances:

  • Edition: Name of the Oracle database product (e.g., Enterprise Edition or Standard Edition).
  • Version: Version of the Oracle database product.
  • Instance Name: Individual name of the Oracle database instance.
  • Role: Role of the database instance (Primary or Secondary).
  • RAC DB Name: Name of the clustered database where the instance belongs to.
  • Installed Date: Date of installation of the Oracle database instance.
  • Relevant Options/Packs: List of database options and management packs (abbreviations only) that are relevant for licensing. You can get more information about relevant options and packs for a database instance by opening the instance dialog.
  • Packs Agreed & Granted: List of enabled management packs (abbreviations only) which the database users are granted access to.
  • CMP Access (Control Management Pack): Displays actual access to features from Control Management Packs (e.g., diagnostic + tuning). This might be the case even if the corresponding packs are disabled, e.g., when special database views (such as V$ACTIVE_SESSION_HISTORY) have been queried with a SELECT.
  • DBA Feature Usage (Database Administration): Displays the list of actually accessed features from management packs (abbreviations only).
  • PDB List (Pluggable Databases): Displays the list of pluggable databases that exist in the selected Oracle database instance.
  • Computer Name: Unique name of the computer system.
  • Type: Operational type of the computer system, displaying either "Physical" or relevant virtualization technology (e.g., VMware, XEN, LPAR).
  • Partitioning: Segmenting type that is important for licensing purposes in case of virtualization (Soft Partitioning or Hard Partitioning).
  • vCenter: Name of the relevant vCenter environment in case of VMware virtualization.
  • Cluster: Name of the hardware cluster where the computer belongs to.
  • Host: Name of the physical computer system where the virtualised computer system is run.
  • CPU: Number of processor sockets equipped with a CPU.
  • Cores: Total number of processor cores available on all sockets.
  • Core Factor: Oracle Core Factor that applies to physical processor according to Oracle terms.
  • Core Value: Value that is calculated by multiplying number of cores by the relevant Core Factor.
  • Special Remarks
  • Sessions Users: Number of current users' sessions.
  • Sessions: Number of current sessions.
  • Sessions Highwater: Highest number of concurrent user sessions since the instance started.
  • Sessions Maximum: Maximum number of concurrent user sessions allowed for the instance.
  • Sessions Warning: Warning limit for concurrent user sessions for the instance.
  • Users: Non-Oracle generated users.
  • Users Maximum: Maximum number of named users allowed for the database.

Preview

On the preview you can see some additional information:

  • Organizational Unit, Cost Center, Location: By default, instances are assigned to the Global organizational unit, cost center, and location. Use the Change Ownership action to link the Oracle instance to another organizational unit, cost center or location.
  • Scan: Date when the Oracle database instance was inventoried last time.
  • Import: Date when the data on the Oracle database instance was imported last time.
  • Synchronization: Date when the data on the Oracle database instance was synchronized to Matrix42 Software Asset & Service Management last time.

Dialog

In the dialog there are the following extra pages that display special information on the database instance:

  • Database Options: Displays a list of all known Oracle database options and management packs with information about relevance and usage.

Click any listed option to view results from the root cause analysis. The Root Cause field will display details from inventory data consolidation and assessment concerning the relevance.

  • Database Features: Displays a list of all known features from Oracle database options and management packs with information about relevance and usage.
  • Database Partitioning: Displays a list of all partitions on this Oracle database instance
  • Complex Systems: Displays a complex system which is a container for this Oracle instance.

Options

This search page displays database options and management packs for all Oracle database instances, details about their relevance and usage along with essential information about the corresponding database instance and computer system. If you click on an option, the Oracle Database Instance preview will appear.

The search page provides the following data:

  • Usage: Indication if the option or pack is in use or not.
  • Result: Indication if the option or pack is relevant for licensing or not.
  • Option: Short name of the option or pack.
  • Option Name: Name of the option or pack.
  • Option Type: Either Option or Pack.
  • Last Scan: Date when the Oracle database instance was inventoried last time.
  • Last Import: Date when the data on the Oracle database instance was imported last time.
  • Instance Name: Individual name of the Oracle database instance.
  • Edition: Name of the Oracle database product (e.g., Enterprise Edition or Standard Edition).
  • Version: Version of the Oracle database product.
  • RAC DB Name: Name of the clustered database where the instance belongs to.
  • Installed Date: Date of installation of the Oracle database instance.
  • Computer Name: Unique name of the computer system.
  • Type: Operational type of the computer system, displaying either "Physical" or relevant virtualization technology (e.g., VMware, XEN, LPAR).
  • Partitioning: Segmenting type that is important for licensing purposes in case of virtualization (Soft Partitioning or Hard Partitioning).
  • vCenter: Name of the relevant vCenter environment in case of VMware virtualization.
  • Cluster: Name of the hardware cluster where the computer belongs to.
  • Host: Name of the physical computer system where the virtualised computer system is run.
  • Summary: Summary of the root cause analysis.

The dialog of an Oracle instance provides some additional information on relevant options.

Features

This search page displays the feature usage on database options and management packs for all Oracle database instances along with the essential information about the corresponding option/pack, database instance, and computer system. If you click on a feature, the Oracle Database Instance preview will appear.

The search page displays the following data:

  • Result: Indication if the option or pack is relevant for licensing or not.
  • Option: Short name of the option or pack.
  • Option Name: Name of the option or pack.
  • Feature Name: Name of the database feature.
  • Usage Status: Indication if the option or pack is in use or not.
  • Usages: Number of feature usages by the database instance that have been tracked. This number might be greater than zero even if the current usage status is False.
  • First Usage: Date when the feature was used the first time.
  • Last Usage: Date when the feature was used the last time.
  • Last Sample Date: Date when the feature usage data was retrieved by the scanner last time.
  • Instance Name: Individual name of the Oracle database instance.
  • Edition: Name of the Oracle database product (e.g., Enterprise Edition or Standard Edition).
  • Version: Version of the Oracle database product.
  • Computer Name: Unique name of the computer system.
  • Asset Status: Lifecycle status of the computer system.
  • Last Import: Date when the data on the Oracle database instance was imported last time.
  • Last Scan: Date when the Oracle database instance was inventoried last time.