GTK Oracle is a GTK 2 interface to Oracle that aids in Oracle application development and testing.. #Database frontend #Oracle frontend #Administrative frontend #GTK #Oracle #Database
GTK Oracle is a GTK 2 interface to Oracle that aids in Oracle application development and testing.
Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, 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, and the Oracle Automatic Workload Repository in Oracle version 10g. Full statistics are available on loaded statements.
� SQL in the text buffer (anything that gets run via the Execute button) is run on it's own thread in the background so it will not block the GUI part, and you can cancel it. This execution thread is started when you start up the program, hopefully never exits, and receives commands via a GLib asynchronous queue, so you can safely keep hitting Execute while a command is running, it will just execute them in order.
� If you log in as SYSDBA you will get a combo box just under the main menubar. Changing the value will execute ALTER SESSION SET CURRENT_SCHEMA='somebody'; so when you browse it will be as if you were this user. Be aware that any SQL you execute will result in SYS being recorded as the parsing user in the cursor cache, however.
� If you want to access the cursor cache or statspack or AWR you will need to log in with SYSDBA privileges. You might be able to get away with simply having SELECT on SYS.V$SQLAREA and SYS.V$SQLTEXT.
� SYS is excluded from the cursor cache browsing results. Otherwise you end up with a mass of recursive SQL, which you are not going to be able to tune and that is the point here. If you're a masochist and you do want to browse recursives I suppose you can just modify the relevant SQL so that SYS is not exculded and recompile. Have fun.
� AWR features are only available on 10G servers.
� DBMS_OUTPUT works, go to Edit->DBMS OUTPUT Enable
GTK Oracle 2.34
add to watchlist add to download basket send us an update REPORT- runs on:
- Linux
- main category:
- Database
- developer:
- visit homepage
Bitdefender Antivirus Free 27.0.35.146
Zoom Client 6.0.3.37634
calibre 7.9.0
4k Video Downloader 1.5.3.0080 Plus / 4.30.0.5655
Context Menu Manager 3.3.3.1
Microsoft Teams 24060.3102.2733.5911 Home / 1.7.00.7956 Work
IrfanView 4.67
7-Zip 23.01 / 24.04 Beta
Windows Sandbox Launcher 1.0.0
ShareX 16.0.1
- 7-Zip
- Windows Sandbox Launcher
- ShareX
- Bitdefender Antivirus Free
- Zoom Client
- calibre
- 4k Video Downloader
- Context Menu Manager
- Microsoft Teams
- IrfanView