OracleInternals

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 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, 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 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)

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