<< Click to Display Table of Contents >>


Top Previous Next

This dialog can be invoked from Extras on Hora's main menu. It allows you to change global settings. It is divided into several pages that can be reached through the tabs across the top.


You may change the Oracle call interface DLL. It is the same setting that you may change in the advanced options of the connect dialog.

All KeepTool products connect to the database server using Oracle's Call Interface (OCI). Therefore an oci.dll file from the $ORACLE_HOME\bin folder must be loaded into memory. The name of this DLL varies depending on the version of the installed Oracle client software. The first time it starts, KeepTool examines your Oracle client software installation and registers the oldest oci.dll file found. You may change this setting here, or by using the Advanced button in the Connection dialog. If you have multiple ORACLE_HOMEs on your computer, make sure that you are pointing to the oci.dll in the correct ORACLE_HOME. KeepTool will use this ORACLE_HOME for connecting to the server.

Startup Window

You may select which window you want Hora to bring up automatically when it starts. You may specify that MDI child windows (those to the right of the Sidebar, and underneath the Toolbar, appear in normal size or maximized. You may also specify the font and background colors of the Sidebar, or set them back to their default values. The default value for the font color has been darkened.

SQL Page

You may set both DBMS_OUTPUT and Java server output on or off, and set the buffer size for both of these outputs.

You may also change the statement id and plan table name that Hora uses for the explain plan command.

You may enable or disable the Automatic Code Completion feature.

You may choose whether a warning message should be displayed when you try to update a table row that has been updated by another user.

You may choose whether code that you create in the SQL Scratchpad or the standalone SQL Editor is automatically saved before execution.

You may choose whether the execution time for Execute Query should appear in the DBMS_OUTPUT window.

A list of extensions determines which file names will be shown in File Explorer's file window. You may modify this list. All entries must be separated by semicolons.


For Oracle8 and later databases, You may select an optimizer mode. This will generate an ALTER SESSION command with the chosen value. If you have the SQL Preview feature active, you will be asked to confirm the setting for any additional sessions that you start.


You may define a color that will be used to alternate with the white rows in all data grids.

You may choose whether Windows XP Ghosting should be disabled in Hora. By default, it is disabled in order prevent problems with closing windows in Windows XP SP1. This option has no effect for other operating systems.


You may change the location of the Templates directory for generating new PL/SQL objects, for example, to point to a shared network directory instead of using Hora's default templates.

Data Contents

There are three options here:

Initially order by PK columns: If this option is set, primary key columns will always appear first, even when they are not the first columns that were defined when the table was originally created.

AutoCommit: This option affects whether changes posted to the server in Tables | Data Contents or the Data Contents Browser will automatically be committed.

Query Execution Breakable: For queries that take more than 2 seconds in Windows XP, this option enables a dialog that allows the query to be cancelled. (In earlier versions of Windows, it appears for all queries if the option is in effect.) It is available in Tables | Data Contents, the Data Contents Browser, and the SQL Scratchpad.


You may change the auto-refresh interval. This is applicable to the graphs on the Performance page.