Program settings

Application settings allow you to control the behavior of the program. Settings are divided into sections for easy changes

General

Program owner - Name/nickname of the user of the program. Informational Used as a filter for sorting data in local database tables, as well as for separating events in the central repository of the program
Language - program language
Type view - the type of views used by default for displaying data (DBA and ALL)
"Maximum point" checkbox - control of the number of points displayed on the chart " Performance monitor "
- 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 settings 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] - Collection of all ORA-***** errors in a separate log file
Switch "Save log" - [On] - Save the program log to a file on disk at shutdown
Switch "Connect at startup" - [On] - Allow the monitoring kernel to start when the program starts. Automatic connection to the database that was monitored the last time it was used
Switch "Backup database during shutdown" - [On] - Back up application databases at shutdown. The backup is saved to the directory .\config\backup\
Switch "Use of the Diagnostic and Tuning options" - [On] - Allow the program to use the views / procedures / packages of the option " Diagnostic and Tuning " Oracle DBMS
Switch "Document versioning" - [On] - Documents are saved as a new version without overwriting previous editions (see section Document repository )

Gen password settings

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

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

SQL 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

LOCALDB

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