Archive for

Performance Tuning for Oracle Developers

One of my recent customers was a company with a somewhat large warehouse (around 60TB) on Oracle 10gR2.  The system was using RAC, though it was a fairly simple setup: two nodes, very large AIX LPARs, workload manually partitioned between them and somewhat evenly balanced.  The most important demand of their business is a large … Continue reading

Developer Access To 10046 Trace Files

Lets suppose you are a DBA at a large company. You have some great developers, and they’re learning all about how to turn on full logging of their code through the 10046 database trace. They just learned how to use this data in summary form to find out – at a very detailed level – … Continue reading


(a) This is my personal blog.

The views expressed on this website are mine alone and do not necessarily reflect the views of my employer.

OakTableLogo-small OCMOCMracattack-icon


Jeremy Schneider

Get every new post delivered to your Inbox.

Join 933 other followers