Program settings

Connect

Setting up a connection to the Oracle DBMS.

Block "Connection list" - a list of saved connections with the Oracle DBMS

Creating a new connection

Select the "New" line in the "Connection list"
From the drop-down list "TNS string or Connection string" select the connection alias (priority method).

Connection aliases are extracted from the TNSNAMES.ORA file, the path to which is specified in the parameters on the "TNS" tab.

CerebroSQL comes bundled with the necessary libraries to work with all supported DBMS. By default, the program uses local libraries, including the local TNSNAMES.ORA file

specify the connection string in full format in the "TNS string or Connection string" block: <server name>: <port> / <servie_name>

The button in the "TNS string or Connection string" block is used to edit the tnsnames.ora file

Fill in the "Login" field - the username under which the connection is made
Fill in the "Password" field - user password
From the drop-down list "Connection mode" select the connection mode or leave it blank if "None"
"Comment" - comment, optional field
"System name" - the name of the system, the field is optional
"Type" - type of database, industrial, test
"TNS Block" - the text of the TNS block for connection, the field is optional
Click the "Save" button

To test the connection, use the "Testing" button

Bulk Testing All Stored Connections

Press the button "Test all"
In the window that opens, click the "Start test" button
Confirm the operation

After testing, connections that are not valid can be deleted with the "Delete" button

General

Program owner - Username/nickname of the program user. Informational Used as a filter for sorting data in the tables of the local database, as well as for separating events in the central repository of the program

Language - the language of the program

Open type is a way to open branches in program trees. Deprecated, left for code compatibility

Type view - the type of default views used to display data (DBA and ALL)

"Maximum point" check - control of the number of points displayed on the "Performance monitor" chart

- displayed number of points (point - 15 second interval)

Switch "All database [Alert]" - [On] - display information from alert.log for all databases on the server

Switch "SPFile and StartupFile" - [On] - generate startup file (controlfile) and SPFile (database parameters file) when connecting to the database

Switch "Save parameter when connect" - [On] - save the contents of v $ parameter in the local database of the program

Switch "Show message" - [On] - Display messages in the tray about problems, errors

Switch "ORA - from logging" - [On] - Collect all ORA - ***** errors into a separate log file

Switch "Save log" - [On] - Save the program log to a file on disk when the work is finished

Switch "Save log errors" - [On] - Force flushing to disk in the error log in the program. Deprecated, left for code compatibility

Switch "Connect at startup" - [On] - Allow the launch of the monitoring kernel at the start of the program. Automatic connection to the database which was monitored during the last use

Switch "Backup database during shutdown" - [On] - Perform a backup of the application databases at shutdown. The backup is saved to the directory. \ Config \ backup \

Switch "Edit default language" - [Off] - Prohibition of editing the default interface language. Switch control locked!

Switch "Use of the Diagnostic and Tuning options" - [On] - Allow the program to use views / procedures / packages of the " Diagnostic and Tuning " option of the Oracle DBMS

Switch "Document versioning" - [On] - Documents are saved as a new version without overwriting previous editions (see the Document repository section)

Gen password settings :

Number of characters - the number of characters in the password (for a password generator)
Check "Special characters" - add special characters
Check "Number" - add numbers
Check "Lower case" - characters in lower case
Check "Upper case" - uppercase characters

TNS

The page for setting the environment parameters of the driver for working with the Oracle DBMS

The program works with a DBMS:

1. Using local libraries version 11.2.0.4

2. Through the installed client on the workstation

Editing parameters:

1. Set the check "Edit configuration"

2. Select a client from the drop-down list

2.1 <Local> - Local libraries

2.2 <Name of installed client> - previously installed client

3. Press the "Apply" button to apply the parameters

Editing the local tnsnames.ora file

Click on the "Edit" button

Environment settings report

Press the "Report" button to display the parameters of the program environment for working with the Oracle DBMS.

Query editor

Completion load drop-down list - Default value for new sheet. Determines how to load hints for database objects.

Work - In real time
Manual - Manual

Switch "Rename history file [tmp dir]" - On - rename temporary files of sheets of the previous session of the program, thereby preserving the work of the previous session.
Switch "Automatically save lists editor" - On - Enable the mechanism of automatic saving of the text of sheets of the query editor to a folder on disk. By default, sheets are saved to files in the directory .\Tmp\lists \<current_date>\ <List_name> .sql
Switch "Show log operation" - On - show a semi-transparent window with a log of operations in the current sheet.
Switch "Copy text new list" - On - when cloning the current sheet ( Ctrl + t ), copy the contents of the sheet into a new sheet.

Monitoring

Switch "To chek the rigth on the object" - check the rights to tables / views when connecting to the database.
Switch "Save SQL text" - save the text of sql queries executed by active sessions. Data collection is performed by the process of collecting data on the load on the database
Switch "The size of the database" - check the size of table spaces
Switch "Easy query" - use "standard" ( using data from dba_free_space ) query or lightweight (without using data from dba_free_space)
Switch "Automatically [ASH or Real-time]" - allow the program to automatically decide on the source of load data in the database. When ASH views are available, a decision is made to use them. If no views are available, the data is taken from the V $ SESSION view. It is recommended to disable this function.
Switch "Use mode Real-time" - use data from V$SESSION to form load profile. It is recommended to use the specified mechanism
Switch "Adjust the timer" - activation of this function forces the system core to adjust the start time of data collection providing a "strict" interval of 1 s. between the moments of the beginning of the execution of requests forming the ASH profile.
Switch "Show background" - collection of information, including on system processes

Setting up and maintaining local application databases

Backup

"Backup directory" - the path to the folder in which to save the backup copies of the application databases upon shutdown.
"Password" - password for program backups

IMPORTANT: the backup is activated automatically when filling in the "Backup directory" and "Password" fields

Management

Shrink - clears the page cache for the selected databases from the "List local database"
Sweep - run the vacuum command (cleaning of pages from garbage) for the selected databases from the "List local database"
Analyze - update statistics for selected databases from the "List local database"
Backup - perform an immediate backup of the selected databases from the "List local database"

Change password

Changing the password for entering the program.

Clear ASH database

Cleaning and compressing the ASH.db base. This database stores data on the load on the database collected by the main core of the program. Since there is a large amount of data received from loaded databases, the specified database tends to grow. The cleanup operation allows you to reduce the size of the database without completely rebuilding it and losing data