Free jdbc oracle software for linux

GTK Oracle is a GTK+ 2 interface to Oracle that aids in Oracle application development and testing.
Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting.
For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, and the Oracle Automatic Workload Repository in Oracle version 10g. Full statistics are available on loaded statements.
Main features:
- manually running your applications SQL, outside of the application itself
- trying to find out what queries your application is even running
- checking and gathering statistics
- comparing plans
- running statspack to evaluate results
- autotracing
- peeking in AWR
- peeking the shared pool / v$sqlarea / statspack SQL
- identifying high-resource SQL then this might be of some help.
Usage:
- SQL in the text buffer (anything that gets run via the Execute button) is run on its own thread in the background so it will not block the GUI part, and you can cancel it. This execution thread is started when you start up the program, hopefully never exits, and receives commands via a GLib asynchronous queue, so you can safely keep hitting Execute while a command is running, it will just execute them in order.
- If you log in as SYSDBA you will get a combo box just under the main menubar. Changing the value will execute ALTER SESSION SET CURRENT_SCHEMA=somebody; so when you browse it will be as if you were this user. Be aware that any SQL you execute will result in SYS being recorded as the parsing user in the cursor cache, however.
- If you want to access the cursor cache or statspack or AWR you will need to log in with SYSDBA privileges. You might be able to get away with simply having SELECT on SYS.V$SQLAREA and SYS.V$SQLTEXT.
- SYS is excluded from the cursor cache browsing results. Otherwise you end up with a mass of recursive SQL, which you are not going to be able to tune and that is the point here. If youre a masochist and you do want to browse recursives I suppose you can just modify the relevant SQL so that SYS is not exculded and recompile. Have fun.
- AWR features are only available on 10G servers.
- DBMS_OUTPUT works, go to Edit->DBMS OUTPUT Enable

JdbcTool project is a collection of command line utilities for making your life easy when working with Java JDBC databases. Included are:

jdbctool:

An interactive command line tool for executing SQL statements.

jdbcdump:

Dump the contents of a database as SQL statements into a file, like mysqldump.

jdbcload

Execute SQL statements from a file (the opposite of jdbcdump)

Currently, only HSQLDB is supported.

JDBC SQL Profiler is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create indexes.

This small tool, released under an Apache-based license connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns and can generate SQL index creation files.

Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.

This tool can be very useful when you have a big volume of queries that you need to analyze not one by one (meaning that the specific time isnt that much of interest), but rather when you want to know what "group" of queries is taking a lot of time, such as queries on the same tables and columns but with different query values. The integrated SQL parser (built with ANTLR) is used to analyze the incoming SELECT queries.

The Swing GUI was based on Apaches Log4J Chainsaw, but all the bugs are mine. Also contributors are welcome to test, make new suggestions, give their opinion and submit patches.

Orakle is an oracle for the desktop to ease choices.

It works similar to the Magic 8 Ball Konfabulator widget.

Dont get too much addicted.

TODO:
* add more answers
* 2/3 lines per text
- maybe resize the theme

Need a Type 3 JDBC Driver for MS Access or SQL Server? Think RmiJdbc!
RmiJdbc project is a client/server JDBC Driver that relies on Java RMI.
All JDBC classes (like Connection, ResultSet, etc...) are distributed as RMI objects, so that you can distribute as you like the access to any database supporting the JDBC API.
In fact, RmiJdbc is just a bridge to allow remote access to JDBC drivers.
Why RmiJdbc?
- You develop a client/server application with databases on Windows (NT)? Use RmiJdbc along with the JDBC/ODBC Bridge, your Windows (NT) databases become remotely accessible in Java.
- You implement a JDBC Driver? Just implement the JDBC classes locally, dont bother with remote access!
- You need serializable JDBC classes? Here they are.
Enhancements:
- Add features/limitations/changes here

GEBORA is an administrative tool for the Oracle Relational Database Management System. GEBORA project is an OpenSource alternative to TOAD.
Since beta-2, GEBORA uses native look-and-feel. This approach looks faster in Windows when huge tables are filled (something about 2000 or more rows).
Main features:
- Send manually created SQL commands to server, showing the results in a table;
- Browse thru all database schemas (users) and its tables and packages;
- Display tables:
- Data (with filter, ordering and printing);
- Columns (can be printed, too);
- Relations (foreign keys) in both directions (referenced tables and tables that references a table);
- Statistics (with unique profile generation and print);
- Creation script (without constraints);
- Display stored procedures source code and parameters;
- Run stored procedures, defining and viewing IN/OUT parameters.

With Oracle Database 10g, the first relational database designed for Grid Computing, your information is securely consolidated and always available. Oracle Database 10g has the lowest total cost of ownership by making the most efficient use of hardware and IT resources. Oracle is the best choice for large enterprises, small and midsize businesses, and departments alike.

Count on the Highest Quality of Service
Oracle Database 10g delivers the response times your users demand and reduces your cost of downtime. Only Oracle offers the availability, scalability, and low-cost benefits of clustering with Oracle Real Application Clusters.

Lower Costs with the Self-Managing Database
Oracle automates time-consuming, error-prone administrative tasks, so DBAs can focus on strategic business objectives. Studies from the Edison Group prove Oracle Database 10g offers superior manageability and significant cost savings over both IBM DB2 8.2 and Microsoft SQL Server 2000.

Build Your Foundation for Grid Computing
Oracle Database 10g with Real Application Clusters and Automatic Storage Management coordinates the use of large numbers of servers and storage acting as one self-managing Grid for the highest quality of service on low-cost, modular hardware.

Oracle Database 10g is the industrys first database designed for grid computing. Low entry-level pricing makes Oracle the best choice for large enterprises and small to midsize businesses alike, with a variety of editions to choose from:

Enterprise Edition

Industry-leading performance, scalability, and reliability for OLTP, decision support, and content management.
View a list of Enterprise Edition options.

Standard Edition

Four-processor version of Oracle Database 10g, including full clustering support.

Standard Edition One

Two-processor version of Standard Edition at an attractive entry-level price.

Personal Edition

Full-featured version for individuals, compatible with the entire Oracle Database family.

Lite Edition

Complete software for building, deploying, and managing mobile database applications.