Online Documentation for SQL Manager for Oracle
The Data Options section allows you to define options for data view. These options will be applied only to this database. Default settings for newly registered databases can be defined on the Grid|Data Options page of the Environment Options dialog.
Use separate connection for each data view within a database
Select this option to use a separate connection for each data view within a database. Disabling this option is recommended if maximum allowed number of connections is too low.
Asynchronous query execution
Check this option to allow executing queries in background mode (asynchronously). Note that this option is only available when the Use separate connections for each data view within a database option is enabled.
Timeout for query execution
Define time limit for query execution (ms). If query execution takes longer time than specified, than the operation will be aborted. Specify '-1' for unlimited timeout.
Timestamp as string
Display Timestamp type as strings.
Also you can set Timestamp and Timestamp with time zone formats in the appropriate fields.
Perform data filtration on client in data view
If enabled, data are filtered by SQL Manager for Oracle (on the client side).
If disabled, SQL filter is used in data view. In this case filtering is performed on the Oracle server with the help of the WHERE clause used in SQL query.
Default grid mode
These options allow you to define the grid mode for data which will be used by default. It can be changes individually for each table from the context menu of the grid.
Load visible records
The grid loads only a fixed number of dataset records into memory. This option minimizes dataset loading time. Automatic sorting, filtering, summary calculations are not supported in this mode.
Load all records
The grid loads all records from a dataset. This option increases the grid performance by reloading only changed dataset records when updating. In this mode all features (automatic sorting, filtering and summary calculations) are available.