Category: Oracle

dbms_stats and no_invalidate

Since at least 10.2.0, Oracle has decided by default when to invalidate a dependent cursor when query optimizer statistics are gathered. You can determine what setting you have by the following: SQL> select dbms_stats.get_param(‘NO_INVALIDATE’) from dual; DBMS_STATS.GET_PARAM(‘NO_INVALIDATE’) ——————————————————————————– DBMS_STATS.AUTO_INVALIDATE SQL>…

Oracle database encryption

Under normal conditions using an out of the box setup, Oracle database datafiles are stored in a proprietary format. Data such as strings of alphabetic characters can be viewed just as they are in the database by the naked eye…

JDBC and Oracle Database Change Notification

Below is a simple example of a cutdown example of using DCN in Oracle with JDBC. I plan on presenting this to our developers as an alternative to the ATG InventoryCache manager module. import java.sql.*; import java.util.*; import oracle.jdbc.*; import…

TIMESTAMP in GV$SQL_BIND_CAPTURE

This has been an issue since at least 10.2.0.3, and appears to still be the case in 11.2.0.3, almost five years later. A TIMESTAMP datatype in GV$SQL_BIND_CAPTURE is not printed. Fortunately, the following works. select anydata.accesstimestamp(value_anydata) from v$sql_bind_capture where sql_id=’&your_sql_id’;

tcpdump to see Oracle errors

Not all exceptions are created equally, and most you can ignore (the one below you can, in general). However, if you have to troubleshoot on JBOSS (or anywhere a Linux application connects to an Oracle database), what is below is…

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…

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=)))…

ltrace kills ocssd.bin which reboots node

The occsd.bin process is the core process which belongs to the Cluster Synchronization Service. This service is responsible for node membership decisions, so when it no longer exists, the server is rebooted. I was attempting to better understand the library…