GsqlR2 is a GTK2 interface for Oracle application devlopment / testing.
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.
· GTK+ version 2.4.x
· Oracle 9 or 10 client libraries are needed,
· Oracle Instant Client will work.
· With Glib 2.6 or greater a .ini file is saved across restarts.
What's New in This Release:
· Explain plan enhancements:
>> next to object name represents filter predicate