Better At Oracle

A collection of tutorials, code and tools to help you get better using Oracle

July 18, 2014

Manually create an ASM database

The steps required to manually create a database on an ASM system.

February 01, 2012

Dumping Blocks

Notes on how to dump block contents for debugging purposes

December 09, 2011

Passing Arrays between Java and Oracle Procedures

All of the steps and working code required to pass arrays from Java to Oracle and back.

December 08, 2011

Array (Batch) Inserts with JDBC

Inserting records in batches is much faster than inserting the same data one row at a time. This article explains how.

December 08, 2011

Less Soft Parsing in Java

How to transparently reduce soft parsing overhead in Java applications with a few connection settings

December 07, 2011

Connect to Oracle from Java

Simple code to connect to Oracle from Java

June 06, 2011

Manually creating a new database on 11gR2

Notes on how to create a new database from the command line, without using the DBCA (Database Configuration Assistant)

June 06, 2011

Installing Oracle 11gR2 on Centos 5.6

Notes on installing Oracle 11gR2 on Cent OS 5.6