Clone this wiki locally
TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and PostgreSQL, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.
In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers -- which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools.
- Handles multiple connections.
- Asynchronus database communication. UI mostly responsive when accessing database.
- Requires no installation on the database side to be fully functional.
- Advanced SQL worksheet.
- Code completion(temporarily disabled in version 3.0).
- 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 & view editing.
- References & dependencies.
- Tab & tree based browsing.
- Object & data filtering.
- PL/SQL editor & debugger.
- Variable watches.
- Line by line stepping.
- Breakpoints(temporarily disabled in version 3.0).
- Debugger SQL output viewing(temporarily disabled in version 3.0).
- Syntax structure tree parsing(temporarily disabled in version 3.0).
- Server tuning.
- Server overview.
- Tuning charts.
- I/O by tablespace & file.
- Performance indicators.
- Raw server statistics.
- Parameter editor (P-file editor).
- Security manager.
- Storage manager with object & extent viewer.
- Session manager.
- Rollback manager with snapshot too old detection.
- SGA & long operations trace.
- Current session information.
- Statistics manager with parallel analysis.
- DBMS alert tool.
- Invalid object browser.
- SQL output viewer.
- Database & schema comparison and server.
- Extract schema objects to SQL scripts.
Ability to add support for new or older Oracle versions without programming.
Well documented plugin API (Only Linux version).
- SQL template help with PL/SQL functions and optimizer hints.
- Full UNICODE support.
- Printing of any list, text or chart.
- Cross platform support. Known to work on Linux, Windows and Solaris.
We just wanted to make sure you know how much we here in the Red Hat IT group appreciate TOra. It's an official departmental application for our Oracle developers for two main reasons - **It's licensed under the GPL** and **It's functionality meets or exceeds the abilities of any proprietary application we've seen**. I've worked for Red Hat for three years and have been using Open Source tools for five, and in that time, TOra is definitely one of the most mature Open Source applications I've ever seen or used. Thank you for your important contributions to the Open Source community.
"This is a very good alternative to Toad or Oracle PL/SQL Developer and it runs off a USB drive ala portable applicaton." "I used to work with another tool, but since i found TOra I'be been using it successfully in dev and prod environments. Good job!" "Great product, compares well with overpriced commercial products. Look forward to more functionalities, like visual query designer, being added."