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 a GPL'd Open Source project that can be freely used for any purpose.

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.

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.