GTKO is an Oracle development tool that utilizes GTK+ 2 technology.
Some of the top features that this tool boasts of include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets, tracing facility, and SQL*Plus-style command scripting. These features make it a great choice for developers who are looking to streamline their development and debugging processes.
One of the key highlights of GTKO is the tree-style SQL statement "explain plan" facility that allows for SQL statement analysis and tuning. Additionally, you can 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, providing you with tons of options for SQL analysis and optimization.
As for the requirements, GTK+ version 2.4.x is a must-have alongside Oracle 9 or 10 client libraries. Gnome libraries are not required, and Oracle Instant Client will work just fine. With Glib >= 2.6 configuration and queries are saved across restarts for added convenience.
In terms of what's new with the latest release, GTKO now offers final, complete support for displaying Oracle object type values in query results. All combinations of embedded object types and collections can be shown and are also fetched in bulk. Additionally, the schema browser now includes more object type details such as inherited attributes and methods, and Virtual Private Database policies.
Overall, GTKO is a well-designed tool that offers great features to Oracle developers. It makes SQL statement analysis and tuning a breeze, and the latest update brings new support and features that users will appreciate.
Version 2.28: N/A