The following information is applicable for Foglight 5.7.5 and higher.
DBO - ASM Agent Required. Topology: DBO_Instance_General
This alarm is invoked upon detecting that monitored instance configured with ASM while ASM agent is not configured. All ASM data collections are stopped until the ASM agent will be configured.
DBO - Alert Log Message. Topology: DBO_Alert_Log
This alarm is invoked for received alert log messages, based on the alert's severity. The alert log file keeps track of general information regarding the instance core activity, as well as the activity of its background processes. Errors associated with these two aspects can indicate availability, usability or performance issues that require immediate attention.
DBO - Alert Log Summary.Topology: DBO_Alert_Errors_Count
This alarm is invoked when the number of errors detected in the alert log exceeds a predefined threshold. The alert log file keeps track of general information regarding the instance core activity, as well as the activity of its background processes. Errors associated with these two aspects can indicate availability, usability or performance issues that require immediate attention.
DBO - Archive Storage Status.Topology: DBO_Archive_Logs_Storage_Data
This alarm fires when the defined archive destination is either invalid or inaccessible. Archive destinations are used for archiving redo logs filled with redo entries. A mandatory archive destination that cannot be used (is invalid) may result in a database failure, which can lead in turn to an application or service failure.
DBO - Array Fetch. Topology: DBO_Top_SQLs_Summary
This alarm is invoked when inefficient use of the array fetch is detected as possibly resulting in wastage of up to a predefined percentage of network packets. When the array size is too low, the roundtrips required to fetch large number of rows increases, this creating overhead on fetching data.
DBO - Backup Job Failure.Topology: DBO_Backup_Data
This alarm is invoked when a backup has failed with an error. Backups are required in order to ensure the ability to restore the database, either prior to performing a point-in-time recovery or when a media failure has damaged a current datafile, control file, or archived log. Successful completion of the backup operation is critical to ensure having a valid backup.
DBO - Blocks Corrupt.Topology: DBO_Cluster_Latency
This alarm is invoked if the percentage of corrupted blocks within the total number of consistent reads block requests exceeds a predefined threshold. The GC corrupted blocks statistics refers to blocks that were corrupted during transfers. A high value of this metric can indicate an IPC, network, or hardware issue.
DBO - CRS Agent Not Configured.Topology: DBO_Instance
This alarm is invoked when the monitored environment is a Real Application Cluster and the CRS agent is not configured. CRS is the infrastructure layer which manages cluster coordination in a RAC environment. When the CRS agent is not configured, alarms on CRS errors and offline resource will not be invoked.
DBO - Cache Hit Ratio Baseline.Topology: DBO_IO_Activity
This alarm is invoked when the value of Cache Hit Ratio has deviated from a predefined baseline.
DBO - Chained Row Ratio Baseline.Topology: DBO_IO_Activity
This alarm is invoked when the value of Chained Row Ratio has deviated from a predefined baseline.
DBO - Cluster Cache Miss.Topology: DBO_Cluster_Latency
This alarm is invoked when the percentage of data blocks that were not found in the local cache, and were therefore requested from a remote instance, exceeds a predefined threshold.
DBO - Cluster GC Convert.Topology: DBO_Cluster_Latency
This alarm is invoked when the average time to convert a GCS resource from Null to Exclusive, Shared to Exclusive, or Null to Shared, exceeds a predefined threshold.
DBO - Cluster GL Convert.Topology: DBO_Cluster_Latency
This alarm is invoked when the average time to retrieve a block by using Global Cache Service exceeds a predefined threshold.
DBO - Cluster GL Get.Topology: DBO_Cluster_Latency
This alarm is invoked when the average time to open a GES (Global Enqueue Services) resource exceeds a predefined threshold.
DBO - Cluster IC Latency.Topology: DBO_Cluster_Latency
This alarm is invoked when the elapsed time for submitting a block request, until the block is received from the interconnect, exceeds a predefined threshold.
DBO - Collection Status.Topology: DBO_Agent_Module_Status
This alarm is invoked when Foglight data collection has failed.
DBO - DG Applied Gap.Topology: DBO_Data_Guard_Destination_Status
This alarm is invoked when the last applied log sequence# on the archive destination indicates a gap that exceeds a predefined threshold. Ensuring that the gap between the standby and the primary instances is kept as small as possible is important in order to prevent failover to the standby from causing large amount of data losses in a crisis situation.
DBO - DG Errors.Topology: DBO_Data_Guard_Status
This alarm fires when the total number of Data Guard errors exceeds a defined threshold. Errors generated from Dataguard status could indicate failure to synchronize the standby environment with the primary.
DBO - DG Received Gap.Topology: DBO_Data_Guard_Destination_Status
This alarm is invoked when the last received log sequence# on the archive destination indicates a gap that exceeds a predefined threshold. Ensuring that the gap between the standby and the primary instances is kept as small as possible is important in order to prevent failover to the standby from causing large amount of data losses in a crisis situation.
DBO - DG Redo Configuration.Topology: DBO_Data_Guard_Status
This alarm is invoked when the numbers of standby redo logs is equal or less than the number of online redo logs. Having a number of standby redo logs that is equal or less than the number of online redo logs increases the likelihood that the primary instance's log writer (LGWR) process will be blocked, because a standby redo log file cannot be allocated on the standby instance.
DBO - Database was never backed up using RMAN.Topology: DBO_Database
This alarm fires when any backup operation has never taken place on this database. If the database has never been backed up, you risk losing all data in the event of storage device (hardware) failure or mistaken deletion. Lack of backup also prevents recovering data to the requested restore point, before any unwanted changes took place.
DBO - Datafile Average Read Time.Topology: DBO_Datafile_IO_Activity
This alarm is invoked when the average read time for a physical read operation on a certain datafile has exceeded a predefined threshold. High latency values for a specific datafile can sometimes indicate that the accessed datafile resides on slow or malfunctioned physical disks. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Datafile Average Write Time.Topology: DBO_Datafile_IO_Activity
This alarm is invoked when the average write time for a physical write operation on certain datafile has exceeded a predefined threshold. High latency values for a specific datafile can sometimes indicate that the accessed datafile resides on slow or malfunctioned physical disks. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Days Since Full Backup.Topology: DBO_Backup_Type_Status
This alarm fires when the number of days that have elapsed since the successful completion of the last full backup exceeds a predefined threshold. Backups are required in order to ensure the ability to restore the database, either prior to performing a point-in-time recovery or when a media failure has damaged a current datafile, control file, or archived log. Successful completion of the backup operation is critical to ensure having a valid backup.
DBO - Days Since Incremental Level 0 Backup.Topology: DBO_Backup_Type_Status
This alarm fires when the number of days that have elapsed since the successful completion of the incremental level 0 backup exceeds a predefined threshold. Backups are required in order to ensure the ability to restore the database, either prior to performing a point-in-time recovery or when a media failure has damaged a current datafile, control file, or archived log. Successful completion of the backup operation is critical to ensure having a valid backup.
DBO - Disk Sorts Ratio Baseline.Topology: DBO_IO_Activity
This alarm is invoked when the value of Disk Sorts Ratio has deviated from a predefined baseline.
DBO - Execute Count Baseline.Topology: DBO_Instance_Statistics
This alarm is invoked when the value of Execute Count has deviated from a predefined baseline.
DBO - Filesystem Estimated Full.Topology: DBO_OS_File_System_Disk
This alarm fires when the estimated time before the filesystem runs out of space falls below a predefined threshold. When a filesystem reaches full capacity,writing data into the said filesystem is no longer possible. This inability to add data is critical if the database's datafiles or control files reside on this filesystem, in which case the database's functionality will be affected.
DBO - Flash Cache Hit Ratio.Topology: DBO_Instance_Statistics
This alarm is invoked when the percentage of block requests resolved from the flash cache falls below a predefined threshold. Block retrieval is carried out significantly faster by accessing the flash cache, as this cache resides on high-performance flash SSD. Low flash cache hit ratio indicates that many blocks are being retrieved from the regular disks, possibly resulting in performance issues.
DBO - Flash Cache Insert Skip.Topology: DBO_Instance_Statistics
This alarm is invoked when the ratio of writes to the flash cache that were skipped (insert skip) as a result of an overloaded DBWR, has exceeded a predefined threshold. Before a buffer is being flushed to the disk, the DBWR flushes the buffer into the flash cache, to allow quicker access in other operations. When the DBWR is overloaded with operations, it will skip flushing buffers to the flashcache, as higher priority is given to other significant activities. A high ratio of skips will cause the flash cache to be less effective, as less data will be available for direct reads from the flash cache instead of the disk.
DBO - Flashback Percentage Non Reclaimable.Topology: DBO_Flashback_Area_Summary
This alarm is invoked when the percentage of non-reclaimable space in the flashback area exceeds a predefined threshold. Reclaimable space refers to space currently utilized by files that can be deleted, such as files that are obsolete under the RMAN retention policy and archives that are no longer needed by Data Guard. When the flashback area becomes full, Oracle automatically deletes eligible files to reclaim space. If the percentage of non-reclaimable space amounts to 100%, Oracle will no longer be able to write to the flashback area. In this case, if a mandatory archive location is set to the flashback area, the database will hang until the flashback area space becomes available again.
DBO - Flashback Percentage Used.Topology: DBO_Flashback_Area_Summary
This alarm is invoked when the percentage of space utilized by the flashback area exceeds a predefined threshold. If the flashback area utilization reaches the allocated size, old flashback logs might be purged within the DB_FLASHBACK_RETENTION_TARGET window, and flashback commands that require the purged data will fail. If a mandatory archive location is set to the flashback area, when the allocated flashback area size has been reached, the database will hang until the flashback area space is available, by freeing up disk space or allocating additional space to the flashback area.
DBO - Full Scan Ratio Baseline.Topology: DBO_IO_Activity
This alarm is invoked when the value of Full Scan Ratio has deviated from a predefined baseline.
DBO - Hard Parse Ratio.Topology: DBO_Instance_Statistics
This alarm is invoked when the percentage of the SQL executions that required hard parsing exceeds a predefined threshold. A hard parse, which requires reloading the SQL query into the shared pool, is a time and resource-consuming operation, due to the overhead involved in shared pool RAM allocation and memory management.
DBO - IO Average Read Time.Topology: DBO_IO_Activity
This alarm fires when the average read time for a physical read operation exceeds a threshold. Bad latency in physical write and read operation can often lead to I/O bottlenecks, which can affect application performance.
DBO - IO Average Write Time.Topology: DBO_IO_Activity
This alarm fires when the average write time for a physical write operation exceeds a threshold. Bad latency in physical write and read operation can often lead to I/O bottlenecks, which can affect application performance.
DBO - Initialization Parameter Modified.Topology: DBO_Initialization_Parameter_Change
This alarm is invoked upon any modification of a parameter in the init.ora parameter file. The Init.ora parameter file controls instance configuration parameters such as memory allocations, behavior of processes, and writing destinations. Changing init.ora parameters can dramatically affect the instance activity, including the instance's performance and availability. Therefore, any modification of the init.ora file should be considered carefully before being carried out. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Instance CPU Baseline.Topology: DBO_Instance_Statistics
This alarm is invoked when the value of Instance CPU has deviated from a predefined baseline.
DBO - Invalid Functions.Topology: DBO_Invalid_Objects
This alarm fires when invalid functions exist in a database schema. Functions in invalid state need to be compiled successfully before they are available to be queried against. In Oracle12C and higher versions this alarm can also be invoked at the PDB level
DBO - Invalid Package Bodies.Topology: DBO_Invalid_Objects
This alarm fires when invalid package bodies exist in a database schema. Package bodies in invalid state need to be compiled successfully before they are available to be queried against. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Invalid Packages.Topology: DBO_Invalid_Objects
This alarm fires when invalid packages exist in a database schema. Packages in invalid state need to be compiled successfully before they are available for execution. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Invalid Procedures.Topology: DBO_Invalid_Objects
This alarm fires when invalid procedures exist in a database schema. Procedures in invalid state need to be compiled successfully before they are available to be queried against. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Invalid Types.Topology: DBO_Invalid_Objects
This alarm fires when invalid types exist in a database schema. Types in invalid state need to be compiled successfully before they are available to be queried against. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Invalid Views.Topology: DBO_Invalid_Objects
This alarm fires when invalid views exist in a database schema. Views in invalid state need to be compiled successfully before they are available to be queried against. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Job Broken.Topology: DBO_Job_Status
This alarm is invoked when a job is either in Broken status or Disabled state (the Disabled state is relevant only for scheduler jobs). A job can become broken in one of the following conditions: .In case of a scheduler job if the number of failed attempts to run exceeds a predefined threshold (max_failures attribute). .In case of a dbms_job - if the status is explicitly set to Broken by the user (using the DBMS_JOB.BROKEN procedure), or has been marked as Broken by Oracle. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Job Queue.Topology: DBO_Jobs_Queue_Db
This alarm fires when the number of jobs that are waiting in the queue exceeds a defined threshold. Too few job queue process may lead to jobs delayed execution.
DBO - Large Pool Full.Topology: DBO_SGA_Components
This alarm is invoked when the large pool's utilization exceeds a predefined threshold. The large pool is used for providing large memory allocations in many situations that arise during the operations of an Oracle database instance, such as session memory in shared server environment, parallel query activity, and RMAN backup and restore operations. If the large pool is not defined, all these operations use the shared pool area.
DBO - Latch Buffer Chain.Topology: DBO_Latches_Activity
This alarm is invoked when the percentage of time spent by sessions waiting on a cache buffer chain latch exceeds a predefined threshold. Cache buffer chain latch protects a buffer list in the buffer cache. These latches are used when searching for, adding, or removing a buffer from the buffer cache. Contention on this latch can indicate the presence of a highly contended-for block (known as a hot block).
DBO - Latch Buffer LRU Chain.Topology: DBO_Latches_Activity
This alarm is invoked when the percentage of time spent by sessions waiting on a cache buffer LRU chain latch exceeds a predefined threshold. Cache buffer LRU chain latch is used for scanning the LRU (least recently used) chain, which contains all of the blocks in the buffer cache. Excessive cache buffer LRU chain-related wait events can result from various causes, such as a small buffer cache, excessive buffer cache throughput, a large number of cache-based sorts, and DBWR that does not keep up with the workload.
DBO - Latch Free.Topology: DBO_Latches_Activity
This alarm is invoked when the percentage of time spent by sessions due to latch free wait events exceeds a predefined threshold. Latch free wait events take place when a session that needs a latch fails to acquire the latch because it is being held by another process. As a result, the session sets an interval, after which a new attempt to acquire the latch will take place. This interval is the "latch free" wait event. There is no ordered queue for the processes waiting on a latch, so the first to grab the latch acquires it. High values of latch free wait percentage can result in severe performance issues.
DBO - Latch Library Cache.Topology: DBO_Latches_Activity
This alarm is invoked when the percentage of time spent by sessions waiting on a library cache latch exceeds a predefined threshold. Library cache latch is used for accessing library cache objects, for the purposes of cursor parsing and execution. High percentage of the library cache latch wait event can indicate that excessive hard parsing is being carried out, resulting in CPU overhead and performance issues.
DBO - Latch Library Cache Pin.Topology: DBO_Latches_Activity
This alarm is invoked when the percentage of time spent by sessions waiting on a library cache pin latch exceeds a predefined threshold. Library cache pin latch is used when a process needs to pin an object in memory in the library cache for examination, ensuring no other processes can update the object at the same time. The library cache pin wait event usually takes place when compiling or parsing a PL/SQL object or a view. Library cache pins must be acquired in exclusive mode, to ensure that the object is not being modified. As a result, the process can spend time waiting for the execution.
DBO - Latch Redo Allocation.Topology: DBO_Latches_Activity
When a redo buffer has been allocated, and the size of the redo is larger than log_small_entry_max_size, the kernel will allocate a redo copy latch. The number of redo copy latches is controlled by the init.ora parameter log_simultaneous_copies (the default number of copies defined in this parameter equals the number of CPU units).The LGWR will get all the redo copy latches before it will write redo, to ensure that no other process is writing to the currently modified redo buffers. High percentage of this latch can indicate that checkpoints and commits are being carried out too frequently, thereby possibly resulting in performance issues.
DBO - Latch Redo Copy.Topology: DBO_Latches_Activity
When a redo buffer has been allocated, and the size of the redo is larger than log_small_entry_max_size, the kernel will allocate a redo copy latch. The number of redo copy latches is controlled by the init.ora parameter log_simultaneous_copies (the default number of copies defined in this parameter equals the number of CPU units).The LGWR will get all the redo copy latches before it will write redo, to ensure that no other process is writing to the currently modified redo buffers. High percentage of this latch can indicate that checkpoints and commits are being carried out too frequently, thereby possibly resulting in performance issues.
DBO - Latch Shared Pool.Topology: DBO_Latches_Activity
This alarm is invoked when the percentage of time spent by sessions waiting on a shared pool latch exceeds a predefined threshold. Shared pool latch protects the allocation of memory from the shared pool. Shared pool latch contention often indicates that too much hard parsing is being carried out, resulting in CPU overhead and performance issues.
DBO - Listener Status.Topology: DBO_Listener_Status This alarm is invoked upon detecting the unavailability of the instance listener. When the listener is unavailable, new connections to the instance cannot be established, and the application usability can be affected.
DBO - Logons Current Baseline DBO_Instance_Statistics This alarm is invoked when the value of Logons Current has deviated from a predefined baseline.
DBO - Long Lock Running.Topology: DBO_Locks_History_Tree_Data
This alarm is invoked when the length of a lock, which was detected during the most recent lock tree snapshot, has exceeded a predefined threshold. Long running locks can lead to a queue of sessions waiting to update the locked object, and in extreme cases, can cause applications to hang.
DBO - OS Cluster Failover.Topology: DBO_OS_Host_Properties
This alarm fires whenever the database has performed a failure to another node in the OS cluster. This could happen due to a server failure (The server that hosted the database prior to the failover), loss of connectivity or high load.
DBO - Parallel Downgraded.Topology: DBO_Parallel
This alarm is invoked when the number of requested parallel queries that downgraded due to lack of resources exceeds a defined threshold. When the number of available parallel servers is insufficient, queries that are supposed to be executed in parallel can run slower than usual, as the query's amount of data remains unchanged, yet fewer servers are available to handle it.
DBO - Parallel Serialized.Topology: DBO_Parallel
This alarm fires when the number of requested parallel queries that serialized due to lack of resources exceeds a defined threshold. Lack of parallel servers may lead to parallel queries being slower than usual, due to serialization of the query.
DBO - Parallel Servers Busy.Topology: DBO_Parallel
This alarm fires when the percentage of busy parallel servers exceeds a threshold. When there are not enough parallel servers available, queries that suppose to be executed in parallel might be downgrade to lower degree of parallelism or even be serialized completely.
DBO - Physical Reads Baseline.Topology: DBO_IO_Activity
This alarm is invoked when the value of Physical Reads has deviated from a predefined baseline.
DBO - Physical Writes Baseline.Topology: DBO_IO_Activity
This alarm is invoked when the value of Physical Writes has deviated from a predefined baseline.
DBO - Process Summary Total Limit.Topology: DBO_Sessions_Summary_Data
This alarm is invoked when the percentage of running processes, within the total number of processes limit, exceeds a predefined threshold. When the number of processes running on the database reaches the processes limit, as defined in the PROCESSES init.ora parameter, new connections to the database will not be allowed and more parallel slaves will not be able to spawn. Listener connections to the instance will be denied even before reaching the actual limit, because the listener would detect that the limit is about to be reached.
DBO - RAC One Node Convert.Topology: DBO_Agent_Model
This alarm is invoked upon detecting that the RAC One Node environment has had more than one node running (up) in the last 45 minutes. Such a state can indicate that the RAC One Node was converted to a RAC environment. All data collection is stopped until either the number of nodes running is again 1, or agent configuration is carried out. If the RAC One Node was indeed converted to RAC, the agent's monitoring mode should be changed accordingly, through the Global Administration > RAC One Node screen, to allow the agent to be monitored as a regular RAC. After carrying out this change, run the Automatic Discovery wizard to re-discover the newly modified agent
DBO - RAC One Node Failover.Topology: DBO_Agent_Model
This alarm fires whenever the database has performed a failure to another node in the OS cluster. This could happen due to a server failure (The server that hosted the database prior to the failover), loss of connectivity or high load.
DBO - Read Consistency Overhead Baseline.Topology: DBO_IO_Activity
This alarm is invoked when the value of Read Consistency Overhead has deviated from a predefined baseline.
DBO - Redo Archive Average Redo Write.Topology: DBO_Redo_Archive_Performance
This alarm fires when the average time (ms) required for writing a redo log entry exceeds a predefined threshold. Slow write operations to the redo logs may require transactions to wait for a long time to be committed to the database, and the resulting wait events can in turn affect the overall application performance.
DBO - Redo Archive Multiple Destinations.Topology: DBO_Redo_Archive_Misc
This alarm fires when multiple archive destinations are defined on the same filesystem.To allow for better redundancy, it is not advisable to define more than one archive destination on the same filesystem, as a filesystem failure can result in the loss of archives on both destinations.
DBO - Redo Archive Time to Fail.Topology: DBO_Archive_Destination_Misc_Data
This alarm fires when the estimated time for a mandatory archive destination to run out of space exceeds a predefined threshold. When a mandatory archive destination runs out of space, it will become invalid, thereby resulting in a database failure.
DBO - Redo Archive Time to Fail Not Mandatory.Topology: DBO_Archive_Destination_Misc_Data
This alarm fires when the estimated time for an archive destination to run out of space exceeds a predefined threshold.When a non-mandatory archive destination runs out of space, the archive destination become invalid; however, this will not result in database failure, as the database will only stop writing archives to this destination.
DBO - Redo Archive Time to Synchronize.Topology: DBO_Redo_Archive_Performance
This alarm fires when the average time(ms) required for writing a redo log entry during a COMMIT exceeds a defined threshold.Slow write operations to the redo logs may require transactions wait for a long time to be committed to the database, and the resulting wait events can in turn affect the overall application performance.
DBO - Redo Archive Unarchived Percentage.Topology: DBO_Redo_Archive_Misc
This alarm fires when the percentage of redo logs that are waiting to be archived exceeds a predefined threshold.A situation where all redo logs are full and no log has yet been archived can lead to extensive wait events, as all transactions need to wait to commit until at least one redo log has been archived.
DBO - Redo Archive if Archived.Topology: DBO_Instance_General
This alarm fires when the database is not in archive log mode. Archive logging prevents the loss of transactions, which can be critical in production environments, as in the event of a disk failure, the database is rolled forward using archive logs. When not in an archive log mode, following a disk failure the database can only be restored to the last backup point in time. All databases in any production environment should be set to archive mode.
DBO - Redo Writes Baseline.Topology: DBO_IO_Activity
This alarm is invoked when the value of Redo Writes has deviated from a predefined baseline.
DBO - Result Cache Find Create Ratio.Topology: DBO_Instance_Statistics
This alarm is invoked when the ratio between find and create operations on the result cache falls below a predefined threshold. Low values of this ratio indicate that the result cache is being underused.
DBO - SGA Data Dictionary Cache.Topology: DBO_Instance_Statistics
This alarm is invoked when the Data Dictionary cache hit ratio falls below a predefined threshold. Ideally, the data dictionary should always hold the entire dictionary in the cache, as performing disk reads to access dictionary metadata is a slow, resource-consuming operation, which can affect the database performance.
DBO - SGA Library Cache.Topology: DBO_Instance_Statistics
This alarm is invoked when the Library cache hit ratio falls below a predefined threshold. When a query cursor is not available in the library cache, the instance is forced to hard parse the query. A hard parse, which requires reloading the SQL query into the shared pool, is a time and resource-consuming operation, due to the overhead involved in shared pool RAM allocation and memory management.
DBO - SGA Shared Pool Used.Topology: DBO_SGA_Components
This alarm is invoked when the utilization of the shared pool exceeds a predefined threshold. The shared pool consists primarily of the library cache, which holds cursors for parsed statements and the dictionary cache for fast, in-memory access to dictionary metadata. If the shared pool is overloaded, excessive hard parsing and possibly instance failure may occur.
DBO - SPI Long Lock Running.Topology: DBO_SPI_Locks_History_Tree
This alarm is invoked when the length of a lock, which was detected during the most recent lock tree snapshot, has exceeded a predefined threshold. Long running locks can lead to a queue of sessions waiting to update the locked object, and in extreme cases, can cause applications to hang.
DBO - SQL PI: SQL PI Experiencing Errors.Topology: DBO_SPI_Alert
This alarm is invoked when there is a disconnection of the SQL PI repository.
DBO - Session Summary Total Limit.Topology: DBO_Sessions_Summary_Data
This alarm fires when the number of sessions currently connected to the database is about to exceed the value defined in the init.ora parameter file. Upon reaching the number of currently connected sessions, the database will refuse new connections, which can result in an application failure.In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Tablespace Used Percentage.Topology: DBO_Tablespace
This alarm fires when the percentage of used space in a tablespace exceeds a predefined threshold. If at least one datafile in the tablespace is configured to extend automatically (Autoextend property is set to ON), this property is taken into account, and the alarm will not be invoked. A tablespace is a set of datafiles that contain data. A tablespace whose storage place becomes full can no longer store additional data; as a result, the application's functionality may be adversely affected. In Oracle12C and higher versions this alarm can also be invoked at the PDB level.
DBO - Total IC Load Baseline.Topology: DBO_Cluster_Latency
This alarm is invoked when the value of Total IC Load has deviated from a predefined baseline.
DBO - UNDO No Space.Topology: DBO_Undo_Activity_Data
This alarm is invoked when, upon requesting Undo space, no space was available in the UNDO tablespace. An undersized UNDO tablespace can affect the instance's ability to maintain the defined undo retention period, thereby leading to "Snapshot Too Old" errors.
DBO - UNDO Snap too Old.Topology: DBO_Undo_Activity_Data
This alarm is invoked when the instance has generated a "Snapshot Too Old" error message. When update to data takes place, an image (snapshot) of the data block before the update took place is kept in the Undo segments, to provide a point-in-time picture of the data for read consistency.When running out of available space for new transactions, the database begins to overwrite expired undo operations; if the database space issue persists, the database may begin overwriting unexpired undo information. If current long-running queries require any of this overwritten undo information for a consistent image of the data, such queries will fail with a "Snapshot Too Old" error.
DBO - Undo Generation Rate Baseline.Topology: DBO_Undo_Summary
This alarm is invoked when the value of Undo Generation Rate has deviated from a predefined baseline.
DBO - Usability Availability.Topology: DBO_Usability
This alarm fires when the percentage of nodes available in the cluster falls below a predefined threshold. When one or more nodes in the cluster are not running (down), the cluster load balance is affected, thereby decreasing the database's overall survivability.
DBO - Usability Availability PDB.Topology: DBO_PDB_Availability
This alarm fires when the PDB is not opened (stopped or mount mode). In a single instance database environment, users will not be able to connect or retrieve any information from the database.
DBO - Usability Availability Single.Topology: DBO_Usability
This alarm fires when the database instance is not running (down).In a single instance database environment, users will not be able to connect or retrieve any information from the database.
DBO - Usability Connection Availability.Topology: DBO_Usability
This alarm fires when the connection to the instance has failed. In a single instance database environment, users will not be able to connect or retrieve any information from the database.
DBO - Usability Connection Time.Topology: DBO_Usability
This alarm fires when the average connection to the database instance exceeds a defined threshold. High latency connections to the database instance could cause severe performance problems, especially for applications connecting to the database for each query and then disconnecting when done.
DBO - Usability OS Connection Availability.Topology: DBO_Usability
This alarm fires when the connection to the Operating System has failed. The server could be down, overloaded or the server might be inaccessible from the network. When the database machine is unavailable the database is unavailable as well, either down or inaccessible, which would cause application failure.
DBO - Usability Response Time.Topology: DBO_Usability
This alarm fires when the database's average response time, in milliseconds, exceeds a predefined threshold. Poor database response time can slow the information retrieval from the database, resulting in degraded user experience.
DBO - User Commit Baseline.Topology: DBO_Instance_Statistics
This alarm is invoked when the value of commits has deviated from a predefined baseline.
DBO - Virtualization Overhead Too High.Topology: DBO_Virtualization
This alarm is invoked when the percentage of Virtualization Overhead exceeds a predefined threshold.
DBO - Wait Active Total Baseline.Topology: DBO_Event_Wait_Data
This alarm is invoked when the value of Wait Active Total has deviated from a predefined baseline.
DBO - Wait Administrative Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Administrative has deviated from a predefined baseline.
DBO - Wait Application Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Application has deviated from a predefined baseline.
DBO - Wait Cluster Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Cluster has deviated from a predefined baseline.
DBO - Wait Commit Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Commit has deviated from a predefined baseline.
DBO - Wait Concurrency Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Concurrency has deviated from a predefined baseline.
DBO - Wait Configuration Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Configuration has deviated from a predefined baseline.
DBO - Wait Network Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Network has deviated from a predefined baseline.
DBO - Wait Other Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Other has deviated from a predefined baseline.
DBO - Wait Queueing Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Queueing has deviated from a predefined baseline.
DBO - Wait Scheduler Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait Scheduler has deviated from a predefined baseline.
DBO - Wait System IO Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait System I/O has deviated from a predefined baseline.
DBO - Wait User IO Baseline.Topology: DBO_Event_Wait_Category
This alarm is invoked when the value of Wait User I/O has deviated from a predefined baseline.