Oracle

A mostly academic post about startup triggers and when they fire in Real Application Clusters

Out of curiosity I wanted to figure out when and how often startup triggers fire in…
Device name persistence in the cloud: OCI

Device name persistence is an important concept for everyone deploying the Oracle database. In this little…
Enforcing a re-parse of a cursor in Autonomous Database. Using a hammer

UPDATE 251208: The original post is now retired, the workaround previously described is no longer necessary.…
JDBC & the Oracle Database: if you want Transparent Application Failover you need the OCI driver

This is the second article in the series of JDBC articles I’m about to publish. It…
JDBC & the Oracle Database: using Maven Central

Over the years I have written a few blog posts about Java and the Oracle database.…
Using wallets with dbca in Oracle 19c

One of the features I haven’t seen blogged about is the option to provide SYS and…
Copying a SQL Plan Baseline from one database to another

Hopefully this post saves you a few minutes looking the procedure up. I know it’ll save…
SQLDeveloper’s “mystats.sql” equivalent

It just occurred to me that I haven’t blogged about SQLDeveloper yet, something I really need…
Silent installation: Oracle Restart 19c, ASM Filter Driver, UEK 5+ edition

As promised in an earlier post here are my notes about installing Oracle Restart with ASM…
Fresh install: Autonomous Health Framework for single instance Oracle 19c

I have been deploying Tracefile Anlyzer (TFA) to every system I’m looking after, whenever possible. Going…