TOra

More screenshots. [click to enlarge]

User comments:

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

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.
Red Hat IT


	TOra - Toolkit For Oracle

This software is licensed under the GPL.

NOTE: TOra was originally written by Henrik Johnson, with enhancements and additions by the open source community, and is now solely developed as an Open Source project. Any references to trial licenses or purchasing licenses purely apply to windows binary builds w/ versions prior to 1.3.15. Newer builds than that are 100% GPL licensed and can be freely used for any purpose.

NOTE: There is an incorrect readme file in the 1.3.18 version that says it is not free software. This file is incorrect, and is already corrected in CVS, but haven't done new release tarballs yet. ALL releases starting with 1.3.15 are 100% GPL licensed. (In fact, source has been GPL for quite some time, but it was not legal for anyone other than Henrik to do windows builds because they could only be done with the Non-Free Qt.)

The project is now being administered by Nathan Neulinger (nneul@neulinger.org). If you are interested in becoming a developer for the project, please contact him.

For commercially supported database tools for Windows please see Toad for Oracle by Quest Software - You can expect more.

Uses the Qt library by TrollTech (www.trolltech.com).

Download:

	Releases available from SourceForge.

TOra 1.3.22:
	Download.
	New in this version Tons of bug fixes and improvements.
TOra 1.3.21:
	Download. (No longer recommended, use 1.3.22 instead.)
	New in this version Solved some problems with linux packaging Check syntax is now working again for Oracle DB Minor fixes to PL/SQL debugger Merged debian changes

Support:

	Online help.
	SourceForge Project Page.
		Report bugs.
		Feature requests.
		Patches.
		Discussion forums.

		Announcement mailinglist.
		Development mailinglist.

		Monitor stable releases.
		Monitor development releases.

Features:

	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.
		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.
		Breakpoints.
		Variable watches.
		Line by line stepping.
		Debugger SQL output viewing.
		Syntax structure tree parsing.

	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.
	Easily extendible.
		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.

Using a binary distribution:

Check the release notes for various binary distributions available for a release.

All distributions require a working Oracle client installation. This includes the statically linked Oracle binary for Linux. Oracle 8i is the only supported client side version (At least Oracle 8.1.5), it might work partially with earlier or later versions of Oracle but it is as of this version not supported (Please try and send me patches).

Installing from source:

Check the file INSTALL in the source distribution.

Planned features:

For more information about planned features check the TODO file in the source distribution. Also check the NEWS file for information about what has already been done in the development version of TOra.

Thank you to:

	Quest Software- For graciously allowing others to take over development of this project without requiring a fork.
	GlobeCom - For support and employment of Henrik during the development of TOra.
	Stefan Rindeskär - Testing, suggestions and brainstorming.
	Alexander (Leo) Bergolth - Access to an Oracle 7.3 database.
	The open source community, for being the users of this product.