List of Oracle Freeware products available in alphabetical order:
Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
Latest version: 2.0.11 (2012-09-16)
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc.
Latest version: 0.85 (2006-07-11)
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above.
Latest version: 1.6 (2011-12-25)
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.
Latest version: 2.13 (2012-DEC)
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.
Latest version: 4.0.14 (2012-09-16)
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free
Latest version: 1.3.1 (2011-01-02)
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.
Latest version: 3.5 (2011-07-11)
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.
Latest version: 2005-09-29
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.
Latest version: 5.1 (2010-SEP)
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.
Latest version: 2008-01-14
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.
Latest version: 3c (2008-04-28)
Trendanalysis on Oracle database with RRDTool.
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.
Latest version: 2003-05-19
Simple command line tool which generates HTML reports of oracle DB schema, including UML diagrams showing relationships. A little fiddly to set up. Free & Open Source
Latest version: 5.0.0 (2010-08-16) Graphical version: 0.99 (2009-02-21)
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.
Latest version: 1.0.18 (2012-05-14)
Oracle SQL Developer is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.
Latest version: 3.2.2 (2012-11-01)
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.
Latest version: 1.6b15 (2011-12-26)
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.
Latest version: v04.02.04 (2007)
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).
Latest version: v112 (2005-03-10)