Топ-100
 
CerebroSQL

ORACLE DB operation monitoring

 
CerebroSQL - General form.jpg
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