We had an issue where a single thread was using all the CPU. We wanted to check it at the command line while troubleshooting. We used what is below… $ jstack 3000 | awk '{if ($1 == "\"Thread-9\"") {i = 1;print $0} else if (i == 1 && $0 != "") {print $0}... »
GoldenGate simple conflict resolution example
I found it incredibly difficult to find a simple working example of an inventory type system where a user at SITE A updates the inventory for ‘Bowl’, while at SITE B another user updates the inventory at the exact same time. Normally, without conflict detection and resolution, each update would be replicated to the... »
ORA-12516 – Possible causes
At least one is when your processes parameter in the database instance(s) has/have been exceeded. java.sql.SQLException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:451) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:535) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:218) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:401) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:288) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:205) at stressRetail.run(stressRetail.java:82)... »
Java date difference in milliseconds
Every time I need to do math on a date in java, I end up googling it. While that isn’t the worst way to do things (hey, it’s probably how you found this ), I wanted something I *knew* would be there. I know there are libraries out there for this, but I usually... »
Instance state values in crsctl
As far as I can tell, the following values represent possible values for the state of instance as reported by crsctl status resource -t expressdb1:oracle:ecomm1:/u01/app/11.2.0/grid/bin# strings -a crsctl.bin | sed -n "16887,16910 p" Not Supported Any State Abnormal Termination Instance Shutdown Corrupted Controlfile Corrupted Dictionary Lost Write Datafile Offline Inaccessible Logfile Stuck Archiver Instance... »
Recording SQL Server CPU utilization for later analysis
Since we are still on SQL Server 2005 (going to 2008 R2 in the next six months), we don’t currently have the performance repository that 2008 does. As such, we recently added a job to record CPU utilization for later analysis. We have a job that runs every five minutes and simply runs the... »