Re: Index Compression clause

hello Billy,
Recently i got a lot of trouble on 8.1.7 HP-UX Tru-64 on compressed indexes. Occasionally (eg merging partitions ) a compressed local index partition can suddenly become non-compressed; without any reason whatsoever.

Users accessing this part of the index will get ORA-600's. Possibly Oracle reads the index; and is "surprised" by the non-compressed part; as the full index is still defined as compressed.

Conclusion: don't mix compressed with non-compressed partitions in 1 index; it doens't work very long and is complicated to fix. Also got ORA-07445 on it; fixed by rebuilding.

good luck,

     Roelof Schierbeek

R.Schierbeek, DBA
e-mail: info_at_bytelifeNSPM.com

"Billy Verreynne" <vslabs_at_onwe.co.za> schreef in bericht
> Anyone confirm, deny or speculate as to whether there is a bug on 8.1.7
> (32bit) with regards the compression clause on indexes?
>
> Platform is HP-UX B11.
>
> I've been getting this intermittantly:
> ORA-00600: internal error code, arguments: [711], [1], [1074596568],
[kdiulk
> - prefix context], [], [], [], []
>
> No errors reported by the client software (but no big surprise there
either
> given their method of dealing with exceptions).
>
> Comment on Metalink says:
> "This error id due to rollbacks on leaf key operations."
>
> Only been getting this error since using compression.. and only on a
> specific table (larger tables with compressed indexes in another schema
> have not resulted in this error).
>
> Am I on the right track thinking this is potentially to do with compressed
> indexes?
> Billy
Received on Wed Jun 18 2003 - 07:08:13 CDT