Re: A SQL statement fails darkly

Kyle,

Thank you very much for investigating metalink for me (unfortunately I don't have access to it). The workaround you suggested helps even for Oracle 8.1.7 and linux.

Best wishes,
Alexei

oraperf_at_yahoo.com (Kyle Hailey) wrote in message news:<3bdecd13.58269787_at_newsfeeds-goliath.1usenet.net>... ...
> From Metalink:
>
> RDBMS Version: 8.1.6
> Operating System and Version: Window NT4
>
> ORA-600:[sdbput_2] may be related to bug 1690703 where this error can
> be signalled during sort operations. The bug is fixed in Oracle9i. A
> workaround is to set sort_area_retained_size = sort_area_size.
>
> I recommend you apply the latest patchset for 8.1.6 on NT, which is
> 8.1.6.3.5 and monitor for further occurrence of these errors. If you
> encounter the ORA-600:[sdbput_2], set sort_area_retained_size =
> sort_area_size to verify it resolves the error.
...
> >In a valiant and sublime effort,Alexei Ustyuzhaninov
> >frowned, dipped a thumb in soot and doodled:
> >
> >>ORA-00600: internal error code, arguments: [sdbput_2], [64716], [],
> >>[], [], [], [], []
Received on Wed Oct 31 2001 - 00:46:26 CST