GTKO 1.72 review

GTKO is a GTK+ 2 Oracle development tool

License: GPL (GNU General Public License) File size: 0K Developer: Colby Farrell

0

GTKO is a GTK+ 2 Oracle development tool. Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, tracing facility, and SQL*Plus-style command scripting.

For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository in Oracle version 10g, plus full AWR reports.

Requirements:
GTK+ version 2.4.x
Gnome libraries not needed.
Oracle 9 or 10 client libraries are needed, Oracle Instant Client will work.
With Glib >= 2.6 configuration and queries are saved across restarts.

What's New in This Release:
Support for external query editor and external result viewers has been added. In Edit->Preferences an external app can be set to use for the SQL editor and for viewing results (as .csv).
With linux kernel 2.6.13 or greater, inotify (file modification tracking) can be used to sync external editor changes to the GTKO textbuffer as they occur. Without inotify, changes made in the external editor are only synchronized when the external editor exits.

To configure inotify you need:
linux, kernel 2.16.3 or greater
support for inotify enabled in the kernel (in the Filesystems section)
run GTKO configure script with the --with-inotify switch

Query result output options have been enhanced. Now you can send output to the screen, log to a file, or neither (if you just want to test the raw select time).
Previously the only way to get results to a file was to send them to the results treeview and then save, which was highly impractical (sometimes impossible) for large result sets.

Separate query trace facility with optional logging to a trace file. Tracing is now in a separate tab next to the query output view and has options for:
picking stats to measure from the VUSD SESSTAT Oracle table
logging stats to a trace file, optionally with the query and the execution plan
automatically set interface to disconnected state for Oracle errors that indicate broken connection; ora-3113 for example

What's New in This Release:
Support for the external SQL editor and result viewer of your choice has been added, executed with F2 and F3 respectively and configurable in Edit->Preferences.
With Linux kernel 2.6.13 or greater, the Inotify interface is used to sync changes while the editor is still open.
Query output can now be sent to the screen, logged to a file, or neither if you just want to test the raw select time.
Previously, the only way to get results to a file was to send them to the screen and then save, which was highly impractical (sometimes impossible) for large result sets.