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.

monitoring rdbms oracle - core
monitoring rdbms oracle - core

press to zoom

press to zoom
monitoring rdbms oracle - core
monitoring rdbms oracle - core

press to zoom


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

General dashboard | 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

monitoring rdbms oracle - core

window structure

Menu - left


"Open" - quick jump to open windows
"Monitoring" - creating database monitoring tasks
"Data transfer" - setting up ETL flows
"MDM" - structured data storage
"Settings" - program settings
"Log" - program operation log
"SQL developer" - query editor

"Lock program" - lock the program
"Exit" - exit the job 

Top Menu

Menu - top


  • Refresh - refresh data by metrics

  • Transaction - Information on transactions in the Oracle database

  • Top SQL - Information on queries 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 DB health metrics

Meaning of metrics in the main CerebroSQL window


For a detailed description, see the "Oracle DB health metrics" section.


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