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
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
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 18.104.22.168
2. Through the installed client on the workstation
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.
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.
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 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
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"
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