Tools and Utilities

This page contains several tools and utilities I've written both personally and with other Oracle experts. While these tools are based on personal and academic research, I've found them useful enough to post for others to use and benefit from.

As most of these tools are released in binary form, and as I have a limited number of systems to build on, a binary for your platform may not be available. If that is the case, please contact me privately. If the source code to a tool is not already provided, please do not ask me for it.

NAEVIUS

NAEVIUS is a third-party application which attaches directly to the Oracle SGA and continuously monitors database performance in the style of ASH. In addition to active session statistic collection, NAEVIUS provides the ability to persist historical session data over time, enabling a DBA to perform AWR-like snapshots and reporting.

Binaries

  • Linux (x86, x86_64)
  • Solaris (x86_64, SPARC)
  • AIX (Itanium)
  • HP-UX (Itanium, PA-RISC)


Source Code

  • C Source Code

OSCAPE

OSCAPE, Oracle SQL Capture and Analysis by Passive Evaluation, is a utility which captures Oracle TCP/IP packets and provides the user with a detailed analysis of Oracle connections, statistics, query activity, and relevant response times.

Binaries

  • Linux (x86, x86_64)
  • Solaris (x86_64, SPARC)
  • AIX (Itanium)
  • HP-UX (Itanium, PA-RISC)


Nakano

Nakano is a log-based transactional replication system for Oracle.

Binaries

  • Linux (x86, x86_64)
  • Solaris (x86_64, SPARC)
  • AIX (Itanium)
  • HP-UX (Itanium, PA-RISC)


Open Source ODBC Driver for Oracle

A fast, compliant, and open source ODBC driver for Oracle written in C on top of OCI.

Binaries

  • Linux (x86, x86_64)
  • Solaris (x86_64, SPARC)
  • AIX (Itanium)
  • HP-UX (Itanium, PA-RISC)


Source Code (Licensed under LGPL)

  • C Source Code

About Me

Jonah H. Harris
Metuchen, New Jersey

I've been using Oracle since 1996 and am intimately familiar with every version of Oracle since version 7. Oracle is a large, fast, and complex system which provides an endless array of things to learn. For more boring details about me and my love affair for Oracle, click here to read more...

Disclaimer

This site and its author are in no way affiliated with Oracle Corporation.

Several detailed documents on this site have kindly been provided by Oracle Corporation solely for informational and noncommercial purposes only.

Topics