RE: Used BMJIs in 9.2.0.4 [we get ORA-600 [12700]s]
- From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Dec 2004 10:09:54 +1100
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx]
>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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
