oracle Metrics

This article describes the metrics that can be configured for the Oracle Database Monitoring (oracle) probe.The following five metrics are used:
uimpga-ga
This article describes the metrics that can be configured for the Oracle Database Monitoring (oracle) probe.The following five metrics are used:
Metric Type
Description
Count
Absolute number of events in the interval. It is calculated as delta between count at the beginning of the interval and at the end. In the first interval, counts are not checked because their interval value cannot be calculated. If there is a "total" value in the message, it means "since the start of the instance".
Gauge
Absolute number, describing the actual state of the system.
Percentage
Calculated percentage, using interval counts. In the first interval, it is calculated from total counts (as the interval count cannot be calculated).
Average
Calculated using interval counts. In the starting interval, it is calculated from absolute counts.
Status
Absolute value like ‘ONLINE’ etc.
 
Contents
QoS Metrics
This section contains the QoS Metrics for the oracle probe.
QoS Name
Units
Description
Version
QOS_ORACLE_active_connection_ratio
Ratio
Calculated as: (active/total) * 100.
Monitors ratio of active connections to total allowed connections.
4.6
QOS_ORACLE_active_users
Count
Counts the currently active Oracle users.
4.6
QOS_ORACLE_buf_cachehit_ratio
Ratio
Calculated as:
(logical-reads - physical-reads)*100 / physical-reads
This metrics tells how often data has been found in cache compared to how often it has to be read from the disk.
4.6
QOS_ORACLE_buf_cachehit_ratio_users
Ratio
Same as buf_cachehit_ratio, only per user. It helps to find a poor query or application.
4.6
QOS_ORACLE_check_dbalive
State
This checkpoint tries to connect to an instance. In case the connection cannot be established, an alert is generated.
Note:
This checkpoint cannot be deactivated.
4.6
QOS_ORACLE_database_size
Bytes
Monitors the space size (in bytes) for each database, log and data files together.
4.6
QOS_ORACLE_datafile_status
State
Reports all files being in other status as 'ONLINE'.
4.6
QOS_ORACLE_dataguard_gap
Archivefiles
Monitors the Dataguard Instance Gap.
4.6
QOS_ORACLE_dataguard_status
State
Monitors the Dataguard Instance Status.
4.6
QOS_ORACLE_dataguard_timegap
Seconds
Monitors the Dataguard Instance Timegap.
4.6
QOS_ORACLE_dbfile_io
Percent
Calculated as:
(Physical-reads / logical-reads) * 100
(Physical-writes / logical-writes) * 100
The greater of the above values is taken for checking. It helps to identify database files with higher I/O contention.
4.6
QOS_ORACLE_dict_cachehit_ratio
Ratio
Calculated as:
(hits - misses) * 100 / hits
Measures number of times where Oracle metadata are found in memory. It could be low at the start of a new application, before new data is placed into the cache.
4.6
QOS_ORACLE_enqueue_timeouts
Timeouts
Measures the number of table and row locks (acquired and converted) that timed-out before they could complete.
4.6
QOS_ORACLE_extents
Extents
Reports the tables that have more extents as threshold.
4.6
QOS_ORACLE_flash_recovery_area_memory_free
Bytes
Monitors the flash recovery area memory free.
4.6
QOS_ORACLE_Gc_av_lock_get_time
Milliseconds
Measures the average interval global lock get time.
4.6
QOS_ORACLE_gc_blocks_corrupt
Blocks
Measures the number of blocks corrupted during transfer.
4.6
QOS_ORACLE_gc_blocks_lost
Blocks
Measures the number of blocks lost during transfer.
4.6
QOS_ORACLE_gc_convert_timeouts
Timeouts
Measures the number of times lock converts in global cache timed out.
4.6
QOS_ORACLE_gc_cr_timeouts
Timeouts
Measures the number of times process request for a consistent read block timed out.
4.6
QOS_ORACLE_gc_fusion_wrt_rto
Ratio
Calculated as:
Fusion writes / physical writes
Measures percentage of blocks written to disk that have been "global dirty".
High number can result from insufficiently sized caches (SGA) or low checkpoint frequency.
4.6
QOS_ORACLE_gc_service_util
Percent
Calculated as:
Global cache service requests / logical reads
Measures global cache utilization.
High number can result from insufficient cache size (SGA). Also, it can indicate inappropriate spread of data and applications in the RAC configuration.
4.6
QOS_ORACLE_lib_cachehit_ratio
Ratio
Calculated as:
(hits - misses)*100 / hits
Measures percentage of times object metadata have been found in memory.
This number can be lower at the start of new application. If it is low for several intervals, the SHARED_POOL_SIZE should be increased.
4.6
QOS_ORACLE_lock_waits
Seconds
Measures number of time a user session was waiting for a lock in last interval.
4.6
QOS_ORACLE_locked_users
Count
Counts the number of users suspended by locks within a timeout.
4.6
QOS_ORACLE_login_count
Users
Measures the number of currently active user session except for user "SYS" and "SYSTEM".
4.6
QOS_ORACLE_long_queries
Count
The checkpoint generates two kinds of alarms:
Alarm if number of long queries is higher than threshold (called "count") - this value is also used as QoS.
4.6
QOS_ORACLE_memory_usage
Bytes
Measures the total amount of memory (in bytes) user sessions consume (PGA).
4.6
QOS_ORACLE_mts_response
Milliseconds
Monitors the average MTS server response time in milliseconds.
4.6
QOS_ORACLE_mts_uga_memory
Bytes
Monitors the MTS user memory consumption.
4.6
QOS_ORACLE_mts_wait
Milliseconds
Monitors the MTS server wait time in milliseconds.
4.6
QOS_ORACLE_resource_utilization_count
count
Monitors the database utilization for resources (Processes, Sessions and Transactions).
4.6
QQOS_ORACLE_resource_utilization_percent
Pct
Monitors the Oracle resource utilization percentage.
4.6
QOS_ORACLE_rollback_seg_status
Availability
Lists the rollback segments which are not ‘ONLINE’.
4.6
QOS_ORACLE_session_waits
Waits
Measures the number of waits in interval.
4.6
QOS_ORACLE_sga_memory
Bytes
Measures the SGA memory usage in bytes by pool.
4.6
QOS_ORACLE_sga_memory_free
Bytes
Measures the SGA free memory usage in bytes.
4.6
QOS_ORACLE_sort_ratio
Ratio
Calculated as:
Memory sorts * 100 / total sorts
Too many disk sorts can cause performance degradation. Check parameter SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE.
4.6
QOS_ORACLE_system_statistics
Count
Displays the available system statistics counters. These counters contain number of events since the instance start.
4.6
QOS_ORACLE_system_statistics_delta
Count
Displays the system statistics delta.
4.6
QOS_ORACLE_system_waits
Waits
Measures the number of system waits by event.
These counters can be used to identify system bottlenecks. Use the table V$SYSTEM_EVENT to find the most "expensive" event.
4.6
QOS_ORACLE_tablespace_alloc_free
Pct
Measures the percentage of free space in already allocated files (not considering the AUTOEXTEND parameter).
Note
: This checkpoint is set inactive by default.
4.6
QOS_ORACLE_tablespace_free
Percent
Measures the percentage of free space in a tablespace, considering the maximal possible tablespace size.
Note:
If auto extend is enabled on your database, this metric always returns approximately 100% free space.  To get an accurate percentage of free space, use QOS_ORACLE_tablespace_temp_free. Oracle Enterprise Manager Console does not consider maximum possible tablespace size on most of its screens.
4.6
QOS_ORACLE_tablespace_size
MB
Measures the total tablespace size.
4.6
QOS_ORACLE_tablespace_status
Availability
Lists the tablespaces that have status different as ‘ONLINE’ or ‘SYSTEM’.
4.6
QOS_ORACLE_tablespace_temp_free
Bytes
Monitors the temporary tablespaces for remaining free space.
4.6
QOS_ORACLE_user_locks
Locks
Lists user holding a lock.
Helps to identify user, blocking other sessions (checkpoint locked_users).
4.6
QOS_ORACLE_pdb_count
Count
Displays the number of pluggable databases (PDBs) in a specific container database (CDB).
Note:
This checkpoint will work only for those profiles that are linked to a CDB connection. For other profiles, no result is displayed even if the checkpoint is enabled. This checkpoint does not have an alarm, by default. However, you can create an alarm for this checkpoint.
4.8
QOS_ORACLE_asm_disk_count
Count
Counts the total number of disks per disk group.
5.1
QOS_ORACLE_asm_disk_bytes_read
Bytes
Monitors the total number of bytes read from the disk.
5.1
QOS_ORACLE_asm_disk_bytes_write
Bytes
Monitors the total number of bytes written to the disk.
5.1
QOS_ORACLE_asm_disk_group_count
Count
Counts the total number of disk groups.
5.1
QOS_ORACLE_asm_disk_group_total_space
Megabytes
Monitors the total space size of each disk group in megabytes.
5.1
QOS_ORACLE_asm_disk_group_used_space
Megabytes
Monitors the used space size of each disk group in megabytes.
5.1
QOS_ORACLE_asm_disk_group_used_space_percent
Percent
Monitors the used space size of each disk group in percentage.
5.1
QOS_ORACLE_asm_disk_read request
Count
Counts the total number of IO read requests for the disk.
5.1
QOS_ORACLE_asm_disk_write_request
Count
Counts the total number of IO write requests for the disk.
5.1
QOS_ORACLE_asm_disk_total_space
Megabytes
Monitors the total space size of each disk in megabytes.
5.1
QOS_ORACLE_asm_disk_used_space
Megabytes
Monitors the used space size of each disk in megabytes.
5.1
QOS_ORACLE_asm_disk_used_space_percent
Percent
Monitors the used space size of each disk in percentage.
5.1
QoS Metrics for the RAC common checkpoints
This section contains the QoS Metrics for the RAC common checkpoints in the oracle probe. RAC is supported and configured only through the Admin Console GUI.
QoS Name
Units
Description
Version
QOS_ORACLE_check_db_alive
Availability
Monitors connectivity to the database instance.
4.6
QOS_ORACLE_tablespace_free
Percent
Monitors tablespaces for the available space.
Note:
If auto extend is enabled on your database, this metric always returns approximately 100% free space.  To get an accurate percentage of free space, use QOS_ORACLE_tablespace_temp_free. Oracle Enterprise Manager Console does not consider maximum possible tablespace size on most of its screens.
4.6
QOS_ORACLE_tablespace_alloc_free
Percent
Monitors tablespaces for available space left in allocated files.
4.6
QOS_ORACLE_tablespace_temp_free
Bytes
Monitors temporary tablespaces for the available space.
4.6
QOS_ORACLE_flash_recovery_area_memory_free
Bytes
Monitors the available memory in the flash recovery area.
4.6
QOS_ORACLE_tablespace_size
MB
Monitors tablespaces size in MB.
4.6
QOS_ORACLE_database_size
MB
Monitors space size (in bytes) for each database, log and data files together.
4.6
QOS_ORACLE_tablespace_status
Availability
Monitors the status of the tablespaces.
4.6
QOS_ORACLE_rollback_seg_status
Availability
Monitors the status of the rollback segments.
4.6
QOS_ORACLE_extents
Extents
Checks for data fragmented segments.
4.6
QOS_ORACLE_asm_disk_count
Count
Counts the total number of disks per disk group.
5.1
QOS_ORACLE_asm_disk_group_count
Count
Counts the total number of disk groups.
5.1
QOS_ORACLE_asm_disk_group_total_space
Megabytes
Monitors the total space size of each disk group in megabytes.
5.1
QOS_ORACLE_asm_disk_group_used_space
Megabytes
Monitors the used space size of each disk group in megabytes.
5.1
QOS_ORACLE_asm_disk_group_used_space_percent
Percent
Monitors the used space size of each disk group in percentage.
5.1
QoS Metrics for the RAC node-specific checkpoints
This section contains the QoS Metrics for the RAC node-specific checkpoints in the oracle probe. RAC is supported and configured only through the Admin Console GUI.
QoS Name
Units
Description
Version
QOS_ORACLE_instance_status
Availability
Monitors the state of the current instance.
4.6
QOS_ORACLE_active_services
Count
Checks for the currently running active services.
4.6
QOS_ORACLE_access_latency
Milliseconds
Monitors the overall latency.
4.6
QOS_ORACLE_gc_cr_blocks_served
Count
Monitors the total number of blocks constructed by the BSP process.
4.6
QOS_ORACLE_gc_cr_block_send_time
Milliseconds
Monitors the total time spent by the BSP process in sending constructed consistent read (CR) blocks.
4.6
QOS_ORACLE_gc_cr_blocks_received
Count
Monitors the total number of blocks received.
4.6
QOS_ORACLE_gc_cr_block_receive_time
Milliseconds
Monitors the total amount of time foreground processes waited for a CR block to be sent through the interconnect.
4.6
QOS_ORACLE_RSRC_MGR_CPU_WAIT_TIME
Milliseconds
Monitors the total number of hundredths of a second that Oracle processes have been in a ready state.
4.6
QOS_ORACLE_AVG_BUSY_TIME
Milliseconds
Monitors the number of hundredths of a second that a processor has been busy executing user or kernel code.
4.6
QOS_ORACLE_buf_cachehit_ratio
Ratio
Monitors the buffer cache-hit ratio.
4.6
QOS_ORACLE_dict_cachehit_ratio
Ratio
Monitors the dictionary cache-hit ratio.
4.6
QOS_ORACLE_lib_cachehit_ratio
Ratio
Monitors the ratio how often SQL queries are found in memory compared to disk.
4.6
QOS_ORACLE_memory_usage
Bytes
Monitors the memory consumption in bytes of Oracle users (PGA).
4.6
QOS_ORACLE_login_count
Users
Checks for the currently running Oracle users.
4.6
QOS_ORACLE_datafile_status
Availability
Monitors the status of the datafiles.
4.6
QOS_ORACLE_enqueue_timeouts
Timeouts
Monitors the number of table and row locks that timed out.
4.6
QOS_ORACLE_mts_response
Milliseconds
Monitors the redo log contention.
4.6
QOS_ORACLE_mts_wait
Milliseconds
Monitors the MTS server wait time in ms.
4.6
QOS_ORACLE_sga_memory
Bytes
Monitors the SGA memory usage.
4.6
QOS_ORACLE_sga_memory_free
Bytes
Monitors the free SGA memory.
4.6
QOS_ORACLE_sort_ratio
Ratio
Monitors the sort ratio (disk, rows and memory).
4.6
QOS_ORACLE_mts_uga_memory
Bytes
Monitors the MTS UGA Memory.
4.6
QOS_ORACLE_user_locks
Locks
Monitors the number of active user locks.
4.6
QOS_ORACLE_locked_users
Count
Monitors the number of users suspended by locks within a timeout.
4.6
QOS_ORACLE_dataguard_status
Avail
Monitors the Dataguard Instance Status.
4.6
QOS_ORACLE_dataguard_gap
Archivefiles
Monitors the Dataguard Instance Gap.
4.6
QOS_ORACLE_dataguard_timegap
Seconds
Monitors the Dataguard Instance Timegap.
4.6
QOS_ORACLE_buf_cachehit_ratio_users
Ratio
Monitors the user buffer cache-hit ratio.
4.6
QOS_ORACLE_sessions_waits
Waits
Monitors the sessions wait counter.
4.6
QOS_ORACLE_system_statistics
Count
Monitors the various system statistical counters since start of the instance.
4.6
QOS_ORACLE_system_statistics_delta
Count
Monitors the delta of various system statistical counters since start of the instance.
4.6
QOS_ORACLE_dbfile_io
Percent
Monitors the database file I/O operations.
4.6
QOS_ORACLE_lock_waits
Seconds
Monitors time in seconds, sessions spent waiting for a lock in interval.
4.6
QOS_ORACLE_gc_service_util
Percent
Monitors the global cache service utilization.
4.6
QOS_ORACLE_gc_cr_timeouts
Timeouts
Monitors the global cache consistent read timeouts.
4.6
QOS_ORACLE_gc_converts_timeouts
Timeouts
Monitors the global cache convert timeouts.
4.6
QOS_ORACLE_gc_blocks_lost
Blocks
Monitors the global cache blocks that are lost.
4.6
QOS_ORACLE_gc_blocks_corrupt
Blocks
Measures the number of blocks corrupted during transfer.
4.6
QOS_ORACLE_gc_av_lock_get_time
Milliseconds
Monitors the average global lock get time in milliseconds.
4.6
QOS_ORACLE_gc_fusion_wrt_rto
Ratio
Monitors the ratio between fusion writes and physical writes.
4.6
QOS_ORACLE_long_queries
Count
Monitors the number of long running queries.
4.6
QOS_ORACLE_resource_utilization_count
Count
Monitors the database utilization for resources.
4.6
QOS_ORACLE_resource_utilization_percent
Percent
Monitors the database utilization for resources.
4.6
QOS_ORACLE_system_waits
Waits
Monitors the system wait counters.
4.6
QOS_ORACLE_active_users
Users
Checks for the currently active Oracle users.
4.6
QOS_ORACLE_active_connection_ratio
Ratio
Monitors the active connection ratio.
4.6
QOS_ORACLE_pdb_count
Count
Displays the number of pluggable databases (PDBs) in a specific container database (CDB).
Note:
This checkpoint will work only for those profiles that are linked to a CDB connection. For other profiles, no result is displayed even if the checkpoint is enabled. This checkpoint does not have an alarm, by default. However, you can create an alarm for this checkpoint.
4.8
QOS_ORACLE_asm_disk_bytes_read
Bytes
Monitors the total number of bytes read from the disk.
5.1
QOS_ORACLE_asm_disk_bytes_write
Bytes
Monitors the total number of bytes written to the disk.
5.1
QOS_ORACLE_asm_disk_read request
Count
Counts the total number of IO read requests for the disk.
5.1
QOS_ORACLE_asm_disk_write_request
Count
Counts the total number of IO write requests for the disk.
5.1
QOS_ORACLE_asm_disk_total_space
Megabytes
Monitors the total space size of each disk in megabytes.
5.1
QOS_ORACLE_asm_disk_used_space
Megabytes
Monitors the used space size of each disk in megabytes.
5.1
QOS_ORACLE_asm_disk_used_space_percent
Percent
Monitors the used space size of each disk in percentage.
5.1
Alert Metrics Default Settings
This section contains the alert metrics default settings for the probe.
Alarm Metric
Warning Threshold
Warning Severity
Error Threshold
Error Severity
Description
Active connection ratio
-
-
75
Major
Monitors the number of users having an active transaction at the moment of snapshot.
Active users
-
-
1
Information
Monitors the ratio of active connections to the total allowed connections.
Buff cache hit ratio
95
Warning
75
Major
Monitors the buffer cache hit ratio.
Buff cache hit ratio users
95
Warning
75
Major
Monitors the user buffer cache hit ratio.
Chained rows
-
-
1
Major
Checks for chained rows in database.
Check db alive
-
-
1
Major
Monitors connectivity to the database instance.
Database size
-
-
100
Information
Monitors space size (in bytes) for each database, logs, and data files together.
Datafile status
-
-
ONLINE
Major
Monitors the status of the datafiles.
Dataguard gap
-
 
10
Major
Monitors dataguard instance gap.
Dataguard status
-
-
1
Major
Monitors dataguard instance status.
Dataguard timegap
-
-
18000
Major
Monitors dataguard instance timegap.
DB file IO
-
-
50
Major
Monitors the database file I/O operations.
Dict cachehit ratio
90
Warning
75
Major
Monitors the dictionary cache-hit ratio.
Enqueue timeouts
-
-
1
Major
Monitors number of table and row locks that timed out.
Extents
-
-
10
Major
Checks for data fragmented segments.
Flash recovery area
-
-
322122547
Major
Monitors flash recovery area memory free.
Avg global lock get time
-
-
30
Major
Monitors the average global lock get time in milliseconds.
Global lock corrupt
-
-
1
Major
Monitors the global cache blocks corrupt.
Global blocks lost
-
-
1
Major
Monitors the global cache blocks lost.
Global convert timeouts
-
-
1
Major
Monitors the global cache convert timeouts.
Global consistent read timeouts
-
-
1
Major
Monitors the global cache consistent read timeouts.
Global fusion writes ratio
-
-
30
Major
Monitors the ratio between fusion writes and physical writes.
Global service utilization
-
-
85
Major
Monitors the global cache service utilization.
Index status
-
-
VALID
Major
Monitors the index status.
Invalid objects
-
-
0
1
0
Information
Major
Major
Checks for invalid objects in database.
Lib cachehit ratio
95
Warning
75
Major
Monitors ratio of how often SQLs are found in memory compared to disk.
Lock waits
-
-
1
1
Information
Major
Monitors time in seconds, for sessions spent waiting for a lock in an interval.
Locked users
-
-
1
300
Major
Information
Monitors the number of users suspended by locks within a timeout.
Login count
-
-
1
Information
Checks for currently logged in users.
Long queries
-
-
1
10
Major
Information
Monitors the number of long running queries.
Memory usage
-
-
2000000
Major
Monitors memory consumption in bytes of Oracle users (PGA).
MTS response
-
-
10
Information
Monitors the MTS server response in milliseconds.
MTS UGA memory
-
-
1
Information
Monitors the MTS UGA memory.
MTS wait
-
-
10
Information
Monitors the MTS server wait time in milliseconds.
No next extents
-
-
1
1
Information
Major
Checks for objects that are unable to allocate next extents.
Redo logs
-
-
1
Major
Monitors redo log contention.
Remaining extents
-
-
10
Major
Checks the remaining number of extents.
Resource util
-
-
90
Major
Monitors database utilization for resources (Processes, Sessions, and Transactions).
Rollback seg status
-
-
ONLINE
Major
Monitors the status of the rollback segments.
Roll back segments
-
-
95
Major
Checks for sufficient number of rollback segments.
Session waits
-
-
1
Information
Monitors the sessions wait counter.
SGA memory
-
-
1
Information
Monitors the SGA memory usage.
SGA memory free
-
-
4096
Information
Monitors free SGA memory.
Sort ratio
-
-
99
Major
Monitors the sort ratio (disk, rows, and memory).
System statistics
-
-
1
Information
Monitors various system statistical counters since last start of instance.
System statistics delta
-
-
1
Information
Monitors delta of various system statistical counters since last start of instance.
System waits
-
-
1
Information
Monitors the system wait counters.
Tablespace alloc free
-
-
10
Major
Monitors tablespaces for space left in allocated files.
Tablespace deficit
-
-
1
1
Information
Major
Checks if the next extent is bigger than available space.
Tablespace free
-
-
10
Major
Monitors tablespaces for available space.
Tablespace size
-
-
1000
Major
Monitors tablespaces size in MB.
Tablespace status
-
-
ONLINE
Major
Monitors the status of the tablespaces
Tablespace temp free
-
-
10000
Major
Monitors temporary tablespaces for available space.
User locks
-
-
1
1
Information
Major
Monitors the number of active user locks.
asm_disk_count
-
-
100
Major
Counts the total number of disks per disk group.
asm_disk_bytes_read
-
-
10000
Major
Monitors the total number of bytes read from the disk.
asm_disk_bytes_write
-
-
10000
Major
Monitors the total number of bytes written from the disk.
asm_disk_group_count
-
-
60
Major
Counts the total number of disk groups.
asm_disk_group_total_space
-
-
-
-
Monitors the total space size of each disk group in megabytes.
asm_disk_group_used_space
-
-
200000
Major
Monitors the used space size of each disk group in megabytes.
asm_disk_group_used_space_percent
-
-
90
Major
Monitors the used space size of each disk group in percentage.
asm_disk_read_request
-
-
10000
Major
Counts the total number of IO read requests for the disk.
asm_disk_write_request
-
-
10000
Major
Counts the total number of IO write requests for the disk.
asm_disk_total_space
-
-
-
-
Monitors the total space size of each disk in megabytes.
asm_disk_used_space
-
-
100000
Major
Monitors the used space size of each disk in megabytes.
asm_disk_used_space_percent
-
-
90
Major
Monitors the used space size of each disk in percentage.
RAC Common Checkpoints
This section contains the alert metrics default settings for the RAC-common checkpoints in the probe. RAC is supported and configured through Admin Console GUI only.
Alarm Metric
Warning Threshold
Warning Severity
Error Threshold
Error Severity
Description
Check dbalive
-
-
1
Major
Monitors connectivity to the database instance.
Tablespace Free
-
-
10
Major
Monitors tablespaces for available space.
Tablespace Alloc Free
-
-
10
Major
Monitors tablespaces for available space in allocated files.
Tablespace Temp Free
-
-
10000
Major
Monitors temporary tablespaces for available space.
Flash Recovery area Memory Free
-
-
322122547
Major
Monitors flash recovery area.
Tablespace Size
 
-
1000
Major
Monitors tablespaces size in MB.
Database Size
 
-
100
Information
Monitors space size for each database in bytes.
Tablespace Status
 
-
Online
Major
Monitors the status of the tablespaces.
Index Status
-
-
Valid
Major
Monitors the index status.
Rollback Segments
-
-
95
Major
Monitors the status of the rollback segments.
Tablespace Deficit
-
-
1
Information
Checks if next_extent is bigger than available space.
Tablespace Deficit
-
-
10
Major
Checks the remaining number of extents.
Remaining Extents
-
-
1
Information
Checks for objects that are unable to allocate next extent.
No Next Extents
-
-
1
Major
Checks for objects that are unable to allocate next extent.
No Next Extents
-
-
0
Information
Checks for invalid objects in database.
Invalid Objects
-
-
1
Major
Checks for invalid objects in database.
Invalid Objects
-
-
0
Major
Checks for invalid objects in database.
Invalid Objects
 
 
1
Major
Checks for chained rows in database.
Chained Rows
-
-
10
Major
Checks for data fragmented segments.
Extents
-
-
1
1
Information
Major
Monitors time in seconds for sessions spent waiting for a lock in interval.
asm_disk_count
-
-
100
Major
Counts the total number of disks per disk group.
asm_disk_group_count
-
-
60
Major
Counts the total number of disk groups.
asm_disk_group_total_space
-
-
-
-
Monitors the total space size of each disk group in megabytes.
asm_disk_group_used_space
-
-
200000
Major
Monitors the used space size of each disk group in megabytes.
asm_disk_group_used_space_percent
-
-
90
Major
Monitors the used space size of each disk group in percentage.
 
RAC Specific Checkpoints
This section contains the alert metrics default settings for the RAC-specific checkpoints in the probe. RAC is supported and configured through Admin Console GUI only.
Alarm Metric
Warning Threshold
Warning Severity
Error Threshold
Error Severity
Description
Instance Status
-
-
1
Major
Monitors the state of the current instance.
Gc cr blocks served
-
-
1
Major
Monitors the total number of blocks constructed by the BSP process.
Gc cr block log send time
-
-
1
Major
Monitors total time spent by the BSP process in sending constructed consistent read (CR) blocks.
Gc cr blocks received
-
-
1
Major
Monitors total number of blocks received.
Gc cr block receive time
-
-
1
Major
Monitors total amount of time foreground processes waited for a CR block to be sent through the interconnect.
Buf cachehit ratio
95
Warning
75
Major
Monitors the buffer cache-hit ratio.
Dict cachehit ratio
90
Warning
75
Major
Monitors the dictionary cache-hit ratio.
Lib cachehit ratio
95
Warning
75
Major
Monitors ratio of how often SQLs are found in memory compared to disk.
Memory usage
-
-
2000000
Major
Monitors memory consumption in bytes of Oracle users (PGA).
Login count
1
Information
-
-
Check for currently running Oracle users.
Datafile status
-
-
ONLINE
Major
Monitors the status of the datafiles.
Enqueue timeouts
-
-
1
Major
Monitors number of table and row locks that timed out.
Redo logs
-
-
1
Major
Monitors redo log contention.
Mts response
10
Information
-
-
Monitors the MTS server response in ms.
Mts wait
10
Information
-
-
Monitors the MTS server wait time in ms.
SGA memory
1
Information
-
-
Monitors the SGA Memory usage.
SGA Memory free
4096
Information
-
-
Monitors the free SGA Memory.
MTS UGA Memory
1
Information
-
-
Monitors the MTS UGA Memory.
User locks
1
Information
1
Major
Monitors the number of active user locks.
Locked users
300
Information
1
Major
Monitors the number of users suspended by locks within a timeout.
Dataguard status
-
-
1
Major
Monitors Dataguard Instance Status.
Dataguard gap
-
-
10
Major
Monitors Dataguard Instance Gap.
Dataguard timegap
-
-
18000
Major
Monitors Dataguard Instance Timegap.
Buf cachehit ratio users
-
-
75
Major
Monitors the user buffer cache-hit ratio.
Buf cachehit ratio users
-
-
95
Warning
Monitors the user buffer cache-hit ratio.
Sessions waits
1
Information
-
-
Monitors the sessions wait counter.
System statistics
1
Information
-
-
Monitors various system statistical counters since start of the instance.
System statistics delta
1
Information
-
-
Monitors delta of various system statistical counters since start of the instance.
System Waits
1
Information
-
-
Monitors the system wait counters.
Dbfile io
-
-
50
Major
Monitors the database file I/O operations.
Lock waits
1
Information
1
Major
Monitors time in seconds for sessions spent waiting for a lock in interval.
Gc service util
-
-
85
Major
Monitors the global cache service utilization.
Gc cr timeouts
-
-
1
Major
Monitors the global cache consistent read timeouts.
Gc converts timeouts
-
-
1
Major
Monitors the global cache convert timeouts.
Gc blocks lost
-
-
1
Major
Monitors the global cache blocks lost.
Gc_blocks_corrupt
-
-
1
Major
Measures the number of blocks corrupted during transfer.
Gc av lock get time
-
-
30
Major
Monitors the average global lock get time in milliseconds.
Gc fusion wrt rto
-
-
30
Major
Monitors the ratio between fusion writes and physical writes.
Long queries
-
-
1
Major
Monitors the number of long running queries.
Long queries
10
Information
-
-
Monitors the number of long running queries.
Resource utilization
-
-
90
Major
Monitors database utilization for resources (Processes,Sessions and Transactions).
Active users
1
Information
-
-
Check for currently active Oracle users.
Active Connection Ratio
-
-
75
Major
Monitors active connection ratio.
Gc cr block send time
-
-
1
Major
Monitors Total time spent by the BSP process in sending constructed consistent-read (CR) blocks.
Session Waits
1
Information
-
-
Monitors the sessions wait counter.
Sort Ratio
-
-
99
Major
Monitors the sort ratio (disk, rows and memory).
asm_disk_bytes_read
-
-
10000
Major
Monitors the total number of bytes read from the disk.
asm_disk_bytes_write
-
-
10000
Major
Monitors the total number of bytes written from the disk.
asm_disk_read_request
-
-
10000
Major
Counts the total number of IO read requests for the disk.
asm_disk_write_request
-
-
10000
Major
Counts the total number of IO write requests for the disk.
asm_disk_total_space
-
-
-
-
Monitors the total space size of each disk in megabytes.
asm_disk_used_space
-
-
100000
Major
Monitors the used space size of each disk in megabytes.
asm_disk_used_space_percent
-
-
90
Major
Monitors the used space size of each disk in percentage.