SAP_Basis Oracle Database Unified Dashboard

The sap_basis Oracle Database Unified Dashboard provides predefined list views to monitor the health and performance of the Oracle Database in the SAP landscape.
uim901
sap_basis_Oracle_UD
The sap_basis Oracle Database Unified Dashboard provides predefined list views to monitor the health and performance of the Oracle Database in the SAP landscape.
 
Contents
 
 
 
: If your Unified Dashboard is not populating with data, make sure all required data sources for the Unified Dashboard are enabled. The required probe must be deployed and must be configured so that required QoS metrics and subkeys or targets are activated. For more information, see the help topic on required data sources for the Unified Dashboard.
SAP_Basis Oracle Database Required Data Sources
This table lists the probes, QoS metrics, and subkeys or targets that must be activated to populate data in the SAP_Basis Oracle Database dashboard. An asterisk (*) means that this QoS brings data for all targets for which it is applicable.
QoS
Subkey/Target
QOS_SAP_ORACLE_AVAILABILITY
*
QOS_SAP_ORACLE_DATABASE_SIZE
*
QOS_SAP_ORACLE_USED_SPACE
*
QOS_SAP_ORACLE_DAILY_GROWTH
*
QOS_SAP_ORACLE_LAST_SUCCESSFUL_UPDATE_STATISTICS
*
QOS_SAP_ORACLE_LAST_SUCCESSFUL_BACKUP
*
QOS_SAP_ORACLE_LAST_BACKUP_STATUS
*
QOS_SAP_ORACLE_BUFFER_CACHE
*
QOS_SAP_ORACLE_LIBRARY_CACHE
*
QOS_SAP_ORACLE_TRANSACTION_LOCK_AGE
*
QOS_SAP_ORACLE_ARCHIVING_LAST_STATUS
*
QOS_SAP_ORACLE_ARCHIVING_DEST_FULL
*
QOS_SAP_ORACLE_FREE_TABLE_SPACE
*
QOS_SAP_ORACLE_USED_TABLE_SPACE
*
For more information about configuring probes, see the documentation for each probe.
Oracle Database Summary
This table displays information about the Oracle Database statistics. Use this chart to view information about the database performance.
Column Name
Description
Availability
The percentage availability of Oracle database.
DB Size
The total size of Oracle database.
Used Space
The total size of currently utilized space in the Oracle database.
Daily Growth
The growth of utilized memory space in the Oracle database since the previous day.
Last Successful Update Statistics Run
The total number of days since the last successful Oracle database update.
Last Successful DB Backup
The total number of days since the last successful Oracle database backup update.
Last DB Backup Status
The status of the last backup.
Oracle Database Performance
This table displays information about the health and performance of Oracle Database.
Column Name
Description
Buffer Cache Hit Ratio
The percentage of utilized Oracle buffer cache
Library Cache Hit Ratio
The percentage of utilized Oracle library cache.
Exclusive Transaction Lock Age
The longest time a transaction lock has been held in exclusive mode.
Archiving Status
The total number of databases in No Archive Log status.
Archiver Destination Remaining Size
The number of Archive logs that will still fit into the archiving directory.
Oracle Tablespace Details
This table displays information about the Oracle tablespace. Use this chart to view information about the storage space.
Column Name
Description
Tablespace - Free Space
The amount of free space in the Oracle table space.
Tablespace - Used Space
The percentage of utilized space in the Oracle table space.