Category: Oracle

Why isn’t my cursor being shared?

This is a decent way to determine why a cursor isn’t being shared, resulting in cache locking during parsing (134 minutes total yesterday, which is very high historically)… SQL> select count(*),sql_id from gv$active_session_history where event = ‘library cache lock’ group…

High latch free waits on Oracle XA transactions

We experienced large waits as well as the associated CPU spikes, when using distributed XA transactions in an ATG/JBOSS application server to Oracle database environment. Oracle “support” was, per usual, of absolutely no help is diagnosing the situation. I honestly…

Schema compare command line tool

I use what is below to quickly compare two Oracle database schema’s tables. It would be trivial to add indexes to the mix. import java.sql.*; import java.util.*; public class schemaDiffer { public static void main(String args[]) { try { Class.forName(“oracle.jdbc.driver.OracleDriver”);…

Simple dbca command line creation

dbca -silent \ -createDatabase -templateName “General_Purpose.dbc” \ -nodelist “expressdb1,expressdb2” \ -gdbName express.home \ -sid express \ -sysPassword ExpressCMH1 \ -systemPassword ExpressCMH1 \ -emConfiguration NONE \ -datafileDestination +DATA \ -redoLogFileSize 50 \ -storageType ASM \ -asmsnmpPassword ExpressCMH1 \ -characterSet AL32UTF8 \…

opatch “patch not applicable”

I saw the exception in the subject title of this post this earlier this week while applying the most recent PSU. Of course, the problem had absolutely nothing to do with whether or not the patch was applicable to the…