top of page
CerebroSQL

CerebroSQL main window (database monitoring)

The main monitoring engine analyzes the operation of an Oracle DBMS instance by 42 parameters, providing comprehensive information about the state of the database.

dashboard

Dashboard - provides quick access to the main modules of the program

CerebroSQL

Monitoring kernel data

The data is generated by the main process of monitoring the operation of the Oracle database. 

The kernel collects, organizes and analyzes 2 classes of data:

  • information on session activity in the database (data is retrieved either from diagnostics pack views or real-time analysis of v$session view data)

  • information about the state of the metrics

CerebroSQL
Структура окна

window structure

CerebroSQL

Action
D.B.
Exec

Open [quick jump to open windows]
editors
Monitoring [create database monitoring tasks]
Data transfer [setting ETL streams]
MDM [structured data warehouse]
Settings [program settings]
Log [program operation log]
SQL developer [query editor]

Lock program
Exit [shutdown] 

Top Menu

CerebroSQL
  • Refresh- update data by metrics

  • transaction - Information on transactions in the Oracle database

  • Top SQL - Information on requests that create the maximum load on the Oracle database

  • session - session manager in Oracle database

  • Active SQL - Oracle ASH Viewer

  • parameter editor - editor of Oracle database parameters

  • error log - error manager​

Состояние метрик работы СУБД Oracle

Oracle DB health metrics

CerebroSQL

 

See the section for a detailed description Oracle DB health metrics

История активных сессий в разрезе классов ожиданий

History of active sessions by classes of expectations

The graph is a display of summary information in the context of waiting classes by active sessions

bottom of page