ORACLE DB operation monitoring
Description of metrics
Active session - the number of sessions in the " Active " status. The data is taken from the v $ session view (the " Session list " opens with the " Active " filter set, the " Session " tab).
Total session - the number of sessions in the database. The data is taken from the v $ session view (the " Session list " opens with the " All " filter set, the " Session " tab).
Count blocking - the number of sessions blocked by other sessions (the " Session list " opens, the " Blocking TREE " tab).
Processes - the number of processes in the database.
Open cursor - the number of open cursors in the database.
Corruption - the number of database blocks in the Corrupt status
Parce count - percentage of requests for which full parsing was performed to the total number of parsed requests. The lower the value, the better. Calculate the value: round ("parse count hard" / "parse count total") * 100
Parse time - Calculation of the value: "parse time cpu" / "parse time elapsed" * 100
Switching logs - average time to switch REDO logs. Depending on the operating mode of the database ( Archivelog or Noarchivelog ), different queries are used
General REDO size - Size in gigabytes of archived logs for the current day. When you click, a window opens with the top objects for generating data in the REDO log
File stat: Reading - the amount of information read from the database during the time between passes by the monitoring engine. When you click, a window opens with additional information about the input / output to the database.
File stat: Write - the amount of information recorded in the database during the time between passes by the monitoring core. When you click, a window opens with additional information about the input / output to the database.
RMAN - Time in minutes elapsed since the last successful backup made using RMAN. The type of backup (Full DB, Incr, Archivelog) is indicated in square brackets. Clicking opens a window for viewing data on database backup using RMAN.
ASM - Name and free space in the disk group with the least amount of free space. When clicked, a window opens to view data on resource use in ASM.
FRA - percentage of free space in FRA ( fast_recovery_area ). The square brackets indicate the maximum amount of data (archived logs) that is allowed to be stored in this area.
Size datafile | * Size datafile - Shows the current size of the database. Depending on the check setting, " Easy query " displays either the current size of all data files or the actual size of the database, taking into account the free space in the data blocks. When you click, a window for viewing information about the tablespace (management, size, ...) opens - the "Tablespace management " section.
@@ Maximizing is the maximum size of the database.
@@ Count - number of tablespaces | data files.
@@ Name [Min] is the name of the tablespace with the minimum amount of free space.
@@ Using [Perc] - The percentage of full table space with the minimum amount of free space.
Reclaimable - The number of megabytes that can be reclaimed in the database by compressing the database objects. When clicked, a window with a list of recommendations opens to free up space in database objects [tables, indexes].
OMF Data - Whether " Oracle Managed Files " is used for data files. When clicked, the OMF parameters management opens.
OMF Log - Whether " Oracle Managed Files " is used for REDO logs. When clicked, the OMF parameters management opens.
UNDO - The number of ORA-01555 errors for the current day. When you click, a window opens with information about the parameters of the UNDO space, analytics.
Destination - Oracle destination status. When at least one destination is in the Invalid status, the metric value changes to Invalid. When you click, a window for setting and viewing statuses opens.
Standby - the status of the base standby dock.
Job active - The number of active jobs ( dbms_job ) at this point in time. When you click, a window opens with additional information about the tasks in the database created through dbms_job
Scheduler active - The number of active jobs ( dbms_scheduler ) at a given time.
Scheduler failed - The number of scheduler jobs that have failed in the current day. When clicked, a window opens with detailed information about errors
Outstanding - Number of warnings from Oracle DBMS. When you click, a window opens with a list of all recommendations
Recyclebin - is the recycle bin included in the database (data is taken from V $ PARAMETER , the value of the recyclebin parameter)
Total PGA used - The amount of memory in the PGA area used by processes. When you click, a window opens with detailed information about the use of PGA resources by processes
SGA max size - The maximum memory size available for the SGA area. When you click, a window opens to view detailed information about the memory parameters of the available database, pools
@@ Buffer cache - The amount of memory allocated from the SGA area for the Buffer cache (area for caching database data blocks).
@@ Shared pool - The amount of memory allocated from the SGA area for the Shared pool (area for storing the library cache, dictionary cache, cache for parallel processes and control structures)
@@ Java pool - The amount of memory allocated from the SGA area for the Java pool (area for storing Java code and data of the Java virtual machine)
@@ Large pool - The amount of memory allocated from the SGA under the Large pool (memory area for transactions working with more than one database, I / O server processes and backup and restore operations)
@@ Streams pool - The amount of memory allocated from the SGA for the Streams pool (the pool is used only for Oracle Streams technology, stores message queues)
Hit ratio - percentage of hits in a particular pool. The indicators are used to analyze the sufficiency of the pool sizes and the total amount of memory for the database to work.
@@ Dictionary cache - a low value of the parameter indicates either an insufficient size of the shared pool or a large number of "new" queries to the dictionary.
@@ Library cache - Reflects the efficiency of the Library cache. A low value indicates insufficient memory for storing PL \ SQL constructs and parsed queries.
@@ Block buffer cache - a low value indicates a lack of memory in the Buffer cache; it also indicates that disk operations were required to execute queries, since the required data blocks were not found in memory and data had to be taken from disk
@@ Latch - A low value indicates latch and contention problems.
Disk sort ratio - the ratio of disk sorts to in-memory sorts. The lower the value, the better
Rollback Segment wait - Percentage of waiting for access to rollback segments. Less is better
Dispatcher workload - load on the dispatcher. Less is better
TOP Wait event - Displays information about the "main wait event" as a percentage for the session and the base as a whole. When you click, a window opens with a full list of wait events in percent for the base and session.
Force: [YES | NO] - change the DB force mode