Contacts     ->      ICQ:    699 512 265,         E-Mail: CerebroSQL@gmail.com

  • YouTube Social  Icon

The main program window

Main      Documentation      Video      Screenshots      Download      Features      Forum      Blog      Support

The main program window contains all the basic information collected by the monitoring-and it is a single location for access to program functions

Menu button
  1. Action [Action] - the section "Menu: Action"

  2. DB [Control] - section "Menu: DB"

  3. Exec [server] - section "Exec"

  4. Open [Open program window by clicking the switch to the window]

  5. Stats [Stats Existence in the context of databases] section "Existence" 

  6. Manual [Instructions] 

    1. Section "User job"

    2. Section "User manual"

    3. Section "Language editor"

  7. Edit Cerebro database [database Editor program (reference)] - the section "Database Cerebro" 

  8. Card of the Server/Databases section of the "Card of the Server/Database"

  9. Settings [Settings] section of "Settings"

  10. Logs [Log files]

  11. Monitor Cerebro [Monitoring of programmes|modules|components] section "Monitor Cerebro"

  12. Query editor [Query editor program] - the section "Query editor"

  13. Close [exit]

  14. About [program Information]

  15. Lock - locks the program

  1. Refresh - to update metric

  2. Transaction [view statistics on transactions] of - section "Menu: Action"

  3. Top SQL [statistics SQL] - the section "Menu: Action"

  4. Session [session management] - section "Session"

  5. SQL Active [detail load] - section "Active SQL"

  6. Parameter edit [editor database settings] - section "Parameter edit"

  7. Error log [error description the family of ORA-errors work programs] section "Error ORA -..... | communications program"

Links "Main window"
  • Box - select DB connection for monitoring system

  • DB version (query)

  • The name of the current running jobs, monitoring system

  • Active session - the current number of sessions in "ACTIVE" status (query). When you click on metric open "Session manager" with exposed filter "Active"

  • Total session - total number of sessions in Oracle database (query). Clicking opens a list of sessions with exposed filter "all session". In brackets indicate the maximum number of sessions (the value of the sessions parameter from v$parameter)

  • Count blocking - All sessions blocked by other sessions (query). When you click open the "Session manager" on the tree tab of the locks

  • Processes - number of processes in Oracle database (query). In brackets indicates the maximum number of processes (the value of the process parameter from v$parameter)

  • Open cursor - the number of open cursors in the database sessions (query). Clicking opens a list of open cursors in the session. In brackets indicate the maximum number of cursors that can be open in the session (the setting of open cursors from v$parameter)

  • Corruption - bad blocks database Oracle (query)

  • Invalid - the number of objects in the database with the status "Invalid" (query). When you click open the compiler for invalid objects

  • Parce count - the percentage of requests which performed full analysis to the total number of parsed queries. The smaller the value, the better. Value calculation: round("parse count hard"/"parse count total")*100 (queries)

  • Parse time - value "parse time cpu"/"parse time elapsed"*100 (query)

  • Switching logs - average time of switching of the REDO logs (query). Depending on the operating mode of the database (Archivelog or Noarchivelog) use different queries

  • General REDO size - the Size in gigabytes of the archived logs for the current day (query). Clicking opens a window with the top of the object to generate data in the online REDO log

  • File stat: Reading - volume information is read from the database during the time between passes-monitoring (query). When you click a window with additional information about I/o in the database

  • Stat File: Write - the amount of information written to the database during the time between passes-monitoring (query). When you click a window with additional information about I/o in the database

  • RMAN - the time in minutes elapsed since the last successful backup performed using RMAN (query). In brackets indicates the type of backup (Full DB, Incr, Archivelog). Clicking opens a window to view data about backing up database using RMAN

  • ASM - Name and free space in a disk group with the least amount of free space (query). Clicking opens a window to view the data on resource usage in ASM

  • FRA - the percentage of free space in the FRA (fast_recovery_area). In brackets indicates the maximum amount of data (archive logs) are allowed to store in this field (query)

  • Size datafile|*Size datafile - Shows the current size of the database. Depending on the installation check "Easy query" displays either the current size of all datafiles or the actual size of the database given the free space in data blocks (query). Clicking opens a window to view information about the tablespace (control, size, ...) - the "Tablespace management"

  • @@Maximizing - maximum database size

  • @@Count - number of tablespaces | number of datafiles

  • @@Name [Min] - the name of the tablespace with a minimum amount of free space

  • @@Using [Perc] - the percentage of occupancy of table space with a minimum amount of free space

  • Reclaimable - Amount of megabytes that can be freed in the database by shrinking the database objects (query). When you click, a window opens with a list of recommendations for free space in the database objects [table, index]

  • OMF Data - whether you use the "Oracle Managed Files" for datafiles. When you click open settings control OMF

  • OMF Log - whether you use the "Oracle Managed Files" for REDO logs. When you click open settings control OMF

  • UNDO - the number of error ORA-01555 for the current day (query). Clicking opens a window with information about the parameters space, UNDO, and Analytics.

  • Destination - the status of the Oracle destination. When finding at least one destination in the status Invalid, the metric value is changed to Invalid (query). When you click open the configuration window and view the status

  • Standby - status standby database (query)

  • Job active - the number of active jobs (dbms_job) at a given point in time (query). When you click, a window opens with additional information about jobs created in the database via dbms_job

  • Scheduler active - number of active jobs (dbms_scheduler) in a given time (query).

  • Scheduler failed - number of jobs scheduler failed (query) for the current day. Clicking opens a window with detailed information about errors

  • Outstanding - number of warnings from the Oracle DBMS (query). When you click, a window opens with a list of all recommendations

  • Recyclebin - recycle bin is enabled in the database (the data is taken from v$parameter, the parameter recyclebin)

  • Total PGA used - amount of memory in the field of PGA used by processes (query). Clicking opens a window with detailed information about the use of resources PGA processes

  • SGA max size - the maximum size of memory available for the SGA region (query). Clicking opens a window to view detailed information about the memory options available database pools

  • @@Buffer cache - the amount of memory allocated from the region under the SGA Buffer cache (an area for caching data blocks DB) (query).

  • @@Shared pool - memory is allocated from the region under the SGA Shared pool (area for storage of the library cache, dictionary cache, the cache for parallel processes and governance structures) (query)

  • @@Java pool - memory is allocated from the region under the SGA Java pool (area for storing Java code and data Java virtual machine) (query)

  • @@Large pool - memory is allocated from the region under the SGA Large pool (memory area for transaction working with more than one database, I/o server processes and backup and recovery) (query)

  • @@Streams pool - memory is allocated from the region under the SGA Streams pool (the pool is only used for Oracle Streams, stores the message queue) (query)

  • Hit ratio - the percent of hits in a given pool. Indicators are used to analyze the adequacy of pool sizes and total memory for running the database

  • @@Dictionary cache - the low value of the parameter says, or about the insufficient size of the shared pool or the large number of new queries to the dictionary (query)

  • @@Library cache - reflects the effectiveness of the Library cache. A low value indicates lack of memory for storing structures in the language PL\SQL, and parsed query (query)

  • @@Block buffer cache - a low value indicates insufficient memory in Buffer cache. Also, specifies that for queries required disk operations as the desired data blocks were not found in the memory and the data had to take from the disk (query)

  • @@Latch - low value indicates a problem with the fixation and competition for the catch (query)

  • Disk sort ratio - the ratio of disk sorts to memory sorts (query). The smaller the value, the better

  • Rollback Segment wait - the percentage of waiting to access the rollback segments (query). The smaller the better

  • Dispatcher workload - load on the dispatcher (query). The smaller the better

  • TOP Wait event - displays information about the "main event" waiting for session and database in general (query). Clicking opens a window with the full list of wait events for the database and session.

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

  • Chart - current load on the database (graphs can be formed using 2 of the monitoring mechanisms, according to ASH and the program itself in Real-time mode). Context menu to navigate to the detail window: "Active SQL"

  • Classes expectations. If you hover class: displays a list of expectations, the chart displays the selected class and CPU consumption

  • History - history of operations