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

dashboard

monitoring rdbms oracle - core

1/2

dashboard

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

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

window structure

Side control panel

"Action"
"DB"
"exec"
"Open" - quick jump to open windows
"Editors"
"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

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