GsqlR2 is a user-friendly software interface designed for Oracle application development and testing, utilizing GTK2 technology. It streamlines the process and enables more efficient software creation and quality assurance.
Furthermore, for SQL statement analysis and tuning, there is a tree-style SQL statement "explain plan" facility that allows for efficient analysis and streamlined optimizing. Additionally, the software also enables users to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository (in Oracle version 10g), and full AWR reports.
To run GsqlR2, users are required to have GTK+ version 2.4.x and Oracle 9 or 10 client libraries (although Oracle Instant Client will also work). Moreover, for those with Glib 2.6 or greater, the software will save a .ini file across restarts.
In the latest release of GsqlR2, there have been exciting explain plan enhancements added. In specific, a ">>" symbol next to object names now represent filter predicate. Overall, GsqlR2 is an intuitive software packed with an incredible amount of useful features that will serve any developer or tester well.
Version 1.46: N/A