Oracle to PostgreSQL

After spending four months tuning an 11g instance and proprietary application SQL using Oracle tools and the Oracle Wait Interface (OWI) I am a big fan of Oracle Enterprise Edition. Oracle Standard Edition does not contain license to internal data collected by the kernel and used by the OWI. This AWR and ASH data licensing…

Read More

Old, Slow and Meticulous…

that’s me when it comes to tuning your Oracle database. Tuning an Oracle database is nothing more than configuring the system and program global areas and locking them into memory. This is relatively simple on Solaris and most Linux distributions. Oracle has been building in tuning features for thirty years. They have succeeded with version…

Read More