GTK Oracle simplifies Oracle application development and testing by providing a GTK 2 interface to Oracle.
The software provides a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting, to name a few. It also has a tree-style SQL statement "explain plan" facility for SQL statement analysis and tuning. You can load SQL statements from different sources, including the runtime cursor cache (V$SQL table), Oracle Statspack repository, and the Oracle Automatic Workload Repository in Oracle version 10g. This feature provides full statistics on loaded statements, making it easier to analyze and optimize SQL statements.
If you're looking to manually run your application's SQL outside of the application itself, check and gather statistics, compare plans, run statspack to evaluate results, autotrace, or peek in AWR, and peek the shared pool / v$sqlarea / statspack SQL, or identify high-resource SQL, the GTK Oracle software can be of immense help.
The software is easy to use. SQL in the text buffer, anything that gets run via the Execute button, is run on its thread in the background. So, it will not block the GUI part, and you can cancel it. The execution thread is started when you start up the program and receives commands via a GLib asynchronous queue, so you can safely keep hitting Execute while a command is running, and it will execute them in order.
The software provides a combo box just under the main menubar if you log in as SYSDBA. Changing the value will execute ALTER SESSION SET CURRENT_SCHEMA='somebody'; so when you browse, it will be as if you were this user. However, any SQL you execute will result in SYS being recorded as the parsing user in the cursor cache. To access the cursor cache or statspack or AWR, you will need to log in with SYSDBA privileges. SYS is excluded from the cursor cache browsing results to avoid recursive SQL. AWR features are only available on 10G servers, and DBMS_OUTPUT works.
The software also comes with several new features in this release, including error location highlighting for all types in the Schema->Source tab, Oracle view browsing merged into the Source->Tables tab, table DDL extract now including the table's associated indexes, constraints, ref. constraints, and grants, and syntax highlighting for comments and Oracle hints, among others.
In conclusion, the GTK Oracle software is an excellent application for Oracle developers and testers. It has many features to simplify and speed up Oracle application development and testing. It is easy to use and provides many useful functionalities, making it an excellent tool for any Oracle developer or tester.
Version 1.41: N/A