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

Hemant,
Have a look at =
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_da= tabase_id=3DNOT&p_id=3D263792.1
(ALERT: Possible Corruption when Using Locally Managed Tablespaces and = ASSM)
and=20
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_da= tabase_id=3DNOT&p_id=3D263792.1
(9.2.0.5 Patch Set - Known Issues)
and also
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_da= tabase_id=3DNOT&p_id=3D283899.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=20
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=20
? 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