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>…
Category: Oracle
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…
RMAN recover with backup taken before RESETLOGS
This functionality has been available since the early 10 release, but I am embarassed to say I have never tested it. Of course, you know where this is going. Last Friday evening, we took a full QA database backup. Over…
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…
Instance not restarting after failure in 11.2.0.3
I thought this was interesting. I always assumed that the RESTART_ATTEMPTS parameter of a cluster resource was only incremented after a failure to restart it. However, after developing an internal training course for our team, I noticed that after a…