Compute_statistics PROBLEM

From: Stephan van Hoof <test_at_test.nl>
Date: Wed, 22 Jan 2003 11:29:40 +0100
Message-ID: <1043231282.886534@newsreader2.wirehub.nl>

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 - 04:29:40 CST