Топ-100
 
CerebroSQL

Monitoring the operation of the Oracle database

The main window is the main screen for displaying information of the monitoring kernel, systematizing the main parameters of the Oracle DBMS

 
monitoring rdbms oracle - core.jpg
Description of metrics

​​

  • Active session - the number of sessions in the "Active" status. The data is taken from the v$session view (opens " Session list " with the filter set to "Active", "Session" tab).

  • Total session - the number of sessions in the database. The data is taken from the v$session view  (opens " Session list " with filter " All ", tab " Session ").

  • Count blocking - number of sessions blocked by other sessions (opens "Session list", "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 - the percentage of requests for which complete parsing was performed to the total number of parsed requests. The lower the value, the better. Value calculation: round("parse count hard"/"parse count total")*100  

  • Parse time - Value calculation:  "parse time cpu"/"parse time elapsed"*100  

  • Switching logs  - average time to switch logs REDO . Depending on the mode of operation of the database ( Archivelog or Noarchivelog ), different queries are used

  • General REDO size - Size in gigabytes of archived logs for the current day. When clicked, 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 core. When clicked, 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 clicked, a window opens with additional information about the input/output to the database.

  • RMAN - Time in minutes elapsed since the last successful backup performed using RMAN. The type of backup is indicated in square brackets (Full DB, Incr, Archivelog)  view database backup data 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 usage in ASM.

  • FRA - percentage of free space in FRA ( fast_recovery_area ). 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 database size. Depending on the setting of the check "Easy query" displays either the current size of all data files or the actual size of the database, taking into account free space in data blocks. When clicked, a window for viewing information about the tablespace (management, size, ...) opens - the "Tablespace management" section.

  • @@Maximizing - maximum database size.

  • @@Count - number of tablespaces | data files.  

  • @@Name [Min] - the name of the table space with the minimum amount of free space.

  • @@Using [Perc] - percentage of table space full with minimum amount of free space.

  • Reclaimable - The number of megabytes that can be freed in the database by compressing 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 datafiles. Clicking opens the OMF parameter management.

  • OMF Log  - Whether "Oracle Managed Files" is used for REDO logs. Clicking opens the OMF parameter management.

  • UNDO - Number of ORA-01555 errors for the current day. When clicked, a window opens with information about the parameters of the UNDO space, analytics.  

  • Destination  - Oracle destination status. If at least one destination is in the Invalid status, the metric value changes to Invalid. When clicked, a window for setting and viewing statuses opens.

  • Standby - the status of the standby database.

  • Job active - The number of active jobs ( dbms_job ) at the current time. When clicked, a window opens with additional information about jobs in the database created via dbms_job

  • Scheduler active  - The number of active jobs ( dbms_scheduler ) at a given time.

  • Scheduler failed  - The number of scheduler jobs that ended with an error for the current day. When clicked, a window with detailed information about errors opens.

  • Outstanding  - Number of warnings from Oracle DBMS. When clicked, a window with a list of all recommendations opens.

  • Recyclebin - whether the basket is included in the database (data is taken from V$PARAMETER , the value of the recyclebin parameter)

  • Total PGA used - Amount of memory in the PGA used by processes. When clicked, 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 clicked, a window opens to view detailed information about the memory parameters of the available database, pools

  • @@Buffercache  -  The amount of memory allocated from the SGA area under Buffer cache (an area for caching database data blocks).

  • @@Shared pool - The amount of memory allocated from the SGA area under the Shared pool (the 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 under the Java pool (an area for storing Java code and Java virtual machine data)

  • @@Large pool - The amount of memory allocated from the SGA area 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 area under the Streams pool (the pool is used only for Oracle Streams technology, stores message queues)

  • Hit ratio - the percentage of hits in a particular pool. The indicators are used to analyze the sufficiency of the size of the pools and the total amount of memory for the database

  • @@Dictionary cache - a low parameter value indicates either an insufficient shared pool size or a large number of "new" requests to the dictionary.

  • @@Library cache - Reflects the efficiency of the Library cache. A low value indicates that there is not enough memory to store 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 complete requests, since the necessary data blocks were not found in memory and the data had to be taken from disk

  • @@Latch - A low value indicates latching problems and latch contention.

  • Disk sort ratio - the ratio of disk sorts to memory sorts. The lower the value, the better

  • Rollback Segment wait - percentage of waiting for access to rollback segments. Less is better

  • Dispatcher workload - dispatcher workload. Less is better

  • TOP Wait event - Displays information about the "top wait event"  as a percentage for the session and the base as a whole. When clicked, a window opens with a complete list of wait events in percentage for the base and session.

  • Force: [YES|NO] - change database force mode