Re: Compute_statistics PROBLEM

Stephan,

A 600 error does not indicate the database is hanging. According to metalink ...

  This ORA-00600 triggers when a latch request violates the ordering rules for obtaining latches and granting the latch would potentially result in a deadlock.
These ordering rules are enforced by assigning each latch a "level#", and checking requested-level vs owned-levels on each latch request.

IMPACT: PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.

SUGGESTIONS: Look for trace files generated at the time of the error. Contact Oracle Support Services and provide the alert.log and associated trace files for further diagnosis.

Stephan van Hoof wrote:
> Hi,
>
> Win2000 / 8.1.7.
>
> When I run:
>
> dbms_utility.analyze_schema('X', 'COMPUTE')
>
> the database hangs (I even cannot connect locally by means of svrmgrl) and
> the alert.log:
>
> ....
> Wed Jan 22 11:12:47 2003
> Errors in file c:\Oracle\ora81\admin\twen\udump\ORA01188.TRC:
> ORA-00600: Interne foutcode, argumenten: [504], [40854264], [8], [1], [cache
> buffers chains], [111], [0], [0].
> ORA-01652: Kan tijdelijke segmenten niet uitbreiden met 13 in tabelruimte
> TEMP.
>
> I only can stop and start the NT-service after this fault...
>
> But, when I run:
>
> execute dbms_utility.analyze_schema('X','ESTIMATE');
>
> there's no problem.
>
> -------------------------------------------------------
> I can imagine there's more TEMP space needed for the COMPUTE.
> But why is the problem with COMPUTE causing Oracle to 'hang'?
> How can I be sure the COMPUTE will give no problems: for example: check and
> re-size TEMP (to what size)?
>
> Thanks
> Stephan
>
>
>
>
>
Received on Wed Jan 22 2003 - 07:14:43 CST