TOra (Toolkit for Oracle) is an free open source GUI tool that allows simple management of your Oracle databases. It features a PL/SQL debugger, an SQL worksheet with syntax highlighting, a database browser and a comprehensive set of database administration tools.
TOra is written in C++ and is built on top of the Qt library, a cross-platform application development framework. It is available under the GNU General Public License.
TOra runs on Unix, Linux, Mac OSX and Windows. Besides Oracle, it can also connect to MySQL and PostgreSQL databases.
TOra was first released on 17 January 2001 and was originally written by Henrik Johnson, with enhancements and additions by the open source community. It is now solely developed as a GPL'd Open Source project that can be freely used for any purpose.
Some of TOra main features include:
- Handles multiple connections
- Asynchronous database communication. UI mostly responsive when accessing database
- Requires no installation on the database side to be fully functional
- Advanced SQL worksheet
- Code completion
- Explain execution plan
- Execution statistics
- SQL syntax highlighting
- Quick menu for often used custom SQL
- Parse error location indication
- Chart visualization of result
- PL/SQL block parsing
- Schema browser.
- Table and view editing
- References and dependencies
- Tab and tree based browsing
- Object and data filtering
- PL/SQL editor and debugger
- Variable watches
- Line by line stepping
- Debugger SQL output viewing
- Syntax structure tree parsing
- Server tuning
- Server overview
- Tuning charts
- I/O by tablespace and file
- Performance indicators
- Raw server statistics
- Parameter editor (P-file editor)