If you identify an Oracle database process consuming a high amount of CPU, or want to trace it for any reason, you can simply run the following script and pass the PID of the offending process when requested. begin for…
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”);…
Print HTTP headers in ATG
ATG provides a class named InsertableServletImpl, which can do pretty much what it sounds like. You insert the servlet to be run in the ATG servlet pipeline where you dictate. This allows us to inject behavior into our application at…
How is the ATG CONFIGPATH built?
The CONFIGPATH in ATG is not an operating system variable. In other words, you don’t issue something like the following… export CONFIGPATH=/directory_a /directory_B /directory_B start_app.sh The CONFIGPATH is pretty much what it sounds like. If you have done any work…
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 \…
Tracing SQL across the wire
This can be really useful in place of database tracing, especially when you want to see the action the *application* takes, and not just what it does in the database. [user@************** common]# tcpdump -A -nn port 1521 | \ >…