Alerts (Oracle Database)

The vROps Management Pack for Oracle Database pulls Oracle Database health indicators and displays them in vRealize Operations as alerts. The critical levels of each alert are closely mapped from Oracle Database to vROps. See the table below for the list of alerts available in the Management Pack.

Alerts List

Name	Description	Recommendation
ASM Disk Free Space is Low	ASM Disk Free Space is Low	ASM Disk Free Space Less Than 15%|ASM Disk Free Space Less Than 10%|ASM Disk Free Space Less Than 5%
ASM Status Not Normal	ASM Status Not Normal	Automatic Storage Management metadata indicates that the disk is known to be part of the Automatic Storage Management disk group, but no disk in the storage system was found with the indicated name|Disk is present in the system, but is ignored by ASM
Archive Logging Disabled	Archive Logging Disabled	All databases should run in archive log mode. Enable archive logging
Average Datafile Read Duration Above Threshold	Average Datafile Read Duration Above Threshold
Fast Recovery Area Not Configured	Fast Recovery Area Not Configured	Fast Recovery Area Should Be Configured
Database Flashback Disabled	Database Flashback Disabled	Database flashback is a useful facility for rapid recovery following a user error and should be enabled
Process Limit Above Threshold	Process Limit Above Threshold	Sessions will fail if the process limit is hit. Increase the limit for processes
Session Usage Above Threshold	Session Usage Above Threshold	Logins will begin to fail if the session limit is hit. Increase the limit for sessions
Datafile Not Available	Datafile Not Available
High CPU Usage	High CPU Usage
High Physical Read I/O Request	High Physical Read I/O Request
High Volume Of User Calls	High Volume Of User Calls
High Redo Logs Generated	High Redo Logs Generated
High Average I/O Time	High Average I/O Time
Long Read Time	Long Read Time
Slow Write Time	Slow Write Time
Database Not Active	Database Not Active	The database instance is not currently active. Connect to the instance and review the process status.
Low Buffer Cache Hit Ratio	Low Buffer Cache Hit Ratio	Review the buffer size configuration.
High Number of CR Blocks Created	High Number of CR Blocks Created
Low Cursor Cache Hit Ratio	Low Cursor Cache Hit Ratio
High Database CPU Time Usage	High Database CPU Time Usage
High Database Wait Time	High Database Wait Time
High Number of Enqueue Deadlocks	High Number of Enqueue Deadlocks
Large Number of Executions	Large Number of Executions
Number of Executions Per Second Exceeded Threshold	Number of Executions Per Second Exceeded Threshold
High Volume of Executions Per Transaction	High Volume of Executions Per Transaction
High I/O Throughput	High I/O Throughput
Low Library Cache Hit Ratio	Low Library Cache Hit Ratio
Slow Table Scans	Slow Table Scans
Low PGA Cache Hit Percentage	Low PGA Cache Hit Percentage
High Write Volume	High Write Volume
Slow Response Time During Transactions	Slow Response Time During Transactions
Low Cache Hit Ratio	Low Cache Hit Ratio
Slow Service Response	Slow Service Response
Large Number of Active Sessions	Large Number of Active Sessions
Large Number of Applications	Large Number of Applications
High Volume of Index Scans Per Transactions	High Volume of Index Scans Per Transactions
Above Normal Query Time	Above Normal Query Time