Oracle originally built its flagship database product with multi-version consistency control. Just as it sounds, multiple versions of a row can exist, albeit only one can exist as the current row version at any given time. It accomplishes this by…
Month: July 2012
awk script to print blocked threads in a java thread dump
-bash-4.1$ cat blocked_threads.awk #!/bin/awk -f { if ($0 ~ “- locked” || $0 ~ “- waiting to lock”) { s[i++]=$0 } } END { for (i in s) { if (s[i] ~ “waiting to lock”) { split(s[i],t) for (j in…
XA transactions and Oracle RAC…
…don’t work in 11.2.0. Perhaps more specifically, I (and everyone I have found blogging about it, as well as on oracle forums) can’t get it to work. The documentation states the following… “Tightly coupled XA transactions no longer require the…
GoldenGate conflict detection in 11.2.1.0 and ignore when multiple statements are in a transaction
In GoldenGate 11.2.1.0, they introduced out of the box CDR (conflict detection and resolution). This is really useful in a bi-directional replication environment such as the one we are building. One question I had about this surrounded what happened if…
Nessus scan of Oracle listener
I thought this was interesting. I found the following in our listener.log file after our security team ran a nessus scan… listener.log:TNS-12502: TNS:listener received no CONNECT_DATA from client listener.log:27-JUN-2012 09:30:52 * (CONNECT_DATA=(COMMAND=VERSION)) * version * 1189 listener.log:27-JUN-2012 09:30:52 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=nessus)(HOST=172.26.253.75)(USER=)))…
Disabling client side PeopleTools debugging
This afternoon, while migrating some objects from development to QA, my PeopleTools session was generating an error message that stated… “Debugging disabled. Communication failure during connect(): 10061. (143,9)” Since I wasn’t actually debugging anything, I opened Configuration Manager and on…
ATG primary key data types
Not much today, this is just a place holder as we evaluate conflict resolution schemes for ATG and Golden Gate. Out of the box, it uses an application based sequence generator (DAS_ID_GENERATOR table). You can (and are encouraged to) prepend…
How to determine PeopleTools version
SQL> select toolsrel from sysadm.psstatus; TOOLSREL ——————– 8.51 SQL>