ORACLE Bug Potentially Affecting Sites Hosting Mosaic Vivarium

If you are running unpatched ORACLE 11.2.0.1.0 64bit Production, you may experience incomplete query results.  The issue is described here:

http://arjudba.blogspot.com/2011/12/select-query-returns-wrong-result-after.html

If you do not apply patches, a work around is to add:

_index_join_enabled=false

to your init.ORA

If you use an spfile, you can issue the following command:

alter system set "_index_join_enabled"=false scope=spfile;