Tools

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

SCAPE4O

SCAPE4O, SQL Capture and Analysis by Passive Evaluation for Oracle, 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

This page has the following sub pages.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>