RE: Used BMJIs in 9.2.0.4 [we get ORA-600 [12700]s]

resent in HTML to see if format is better Hemant,
Have a look at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT <http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=263792.1> &p_id=263792.1 (ALERT: Possible Corruption when Using Locally Managed Tablespaces and ASSM) and
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT <http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=263792.1> &p_id=263792.1 (9.2.0.5 Patch Set - Known Issues)
and also
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT <http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=283899.1> &p_id=283899.1 (9.2.0.6 Patch Set - Known Issues)

HTH,
Bruce Reardon

-----Original Message-----
From: Hemant K Chitale
Sent: Wednesday, 8 December 2004 2:48 AM To: Subbiah, Nagarajan; oracle-l_at_freelists.org

On 9.2.0.4 64-Bit Solaris.
Yes, we have had corrupt indexes -- detected either when the user reports ORA-600 [12700] {also logged in the alert.log} or when we run an ANALYZE TABLE ... VALIDATE STRUCTURE CASCADE

We are now investigating recreating the BMJIs periodically. Another option, as recommended by Oracle was to upgrade to 9.2.0.5 However, you state that there are some bugs with ASSM and BMIs in 9.2.0.5 ? Can you provide some bug numbers ?
Hemant

At 12:23 AM Friday, Subbiah, Nagarajan wrote:
>Any index corruption bug associated with this?
>
>If you use the ASSM and you are on 9.2.0.5, There are some known bugs with
>bitmap indexes.
>
>-----Original Message-----
>From: Hemant K Chitale [ mailto:hkchital_at_singnet.com.sg]
>Sent: Thursday, December 02, 2004 11:01 AM
>
>9.2.0.4 64-bit on Solaris 8
>Anyone used BitMap Join Indexes successfully ?
We keep getting occassional ORA-600 [12700] {Index entry invalid} and have
>to rebuild the Indexes.
>The application schema has been designed by a vendor.
>Hemant K Chitale

NOTICE
This e-mail and any attachments are private and confidential and may contain privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed.

--
http://www.freelists.org/webpage/oracle-l