Free jdbc driver for oracle 10g 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

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.

libdbi implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl.
Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by using this framework.
The libdbi-drivers project provides the database-specific drivers for the libdbi framework. The drivers officially supported by libdbi are:
- Firebird/Interbase
- FreeTDS (provides access to MS SQL Server and Sybase)
- MySQL
- PostgreSQL
- SQLite/SQLite3
The following drivers are in various stages of completion and are supposed to be included into the next release:
- mSQL
- Oracle
Enhancements:
- This release fixes a packaging error in 0.8.2. There are no source code changes.

Oracle::Trace is a Perl Module for parsing Oracle Trace files.

SYNOPSIS

use Oracle::Trace;

print Oracle::Trace->new($tracefilename)->parse->test_report;

Currently the parsing and statistics are very rudimentary, and in certain matters may be fundamentally flawed - you have been warned! Expect this to improve as further development takes place.

new

Create a new object for a given Orace Trace file.
my $o_trc = Oracle::Trace->new($tracefile);

init

Initialise the object (check the tracefile).
$o_trc->init.

opentracefile

Perform basic exists/read/etc. checks on given tracefile.
Returns object or undef.
$o_trc = $o_trc->checkfile($tfile);

header

Return the Header object.
my $o_hdr = $o_trc->header;

entries

Return Entry objects which comply with given regex criteria.
my @o_ents = $o_trc->entries(type=>EXEC #d+, key=>dep, value=>0);

oids

Return the unique object ids for the currently known Entryies
my @oids = $o_trc->oids;

footer

Return the Footer object
my $o_ftr = $o_trc->footer;

test_report

Return a simple test_report of the current object.
print $o_trc->test_report(string);

mini_report

Return a simple string of descending order timings for the statements retrieved from the given objects.
my $s_str = $o_trc->mini_report($i_max, @o_objs);

Note that we use microsecond resolution for Oracle 9i and above and centisecond resolution otherwise

cx_Oracle is a Python extension module that allows access to Oracle, and conforms to the Python database API specifications. cx_Oracle module is currently built against Oracle 8.1.7, Oracle 9.2, and Oracle 10.2.
This API has been defined to encourage similarity between the Python modules that are used to access databases. By doing this, we hope to achieve a consistency leading to more easily understood modules, code that is generally more portable across databases, and a broader reach of database connectivity from Python.
The interface specification consists of several sections:
- Module Interface
- Connection Objects
- Cursor Objects
- DBI Helper Objects
- Type Objects and Constructors
- Implementation Hints
- Major Changes from 1.0 to 2.0
Enhancements:
- This release adds methods to LOB objects in order to improve performance of reading/writing LOB values.
- It also fixes support for native doubles and floats in Oracle 10g.
- Support was added for autocommit mode and reading/writing the size of the statement cache.
- A hook for returning objects other than tuples from cursors was also added.