Re: [Q] How much temporary space is needed to run ANALYZE command?

From: Jonathan Lewis <ora_mail_at_jlcomp.demon.co.uk>
Date: 1996/11/29
Message-ID: <329F63DC.6AC6_at_jlcomp.demon.co.uk>#1/1


Kevin Loney wrote:

>
> but it's not reliable imho. I have a friend who was having lots of problems
> with her system - wrong plans chosen by the CBO, etc. Her table is over
> 300 million records in size. She runs a compute statistics - using a 45G
> temp tablespace - and the problems disappear. Use Compute statistics until
> you run out of disk space to waste on Temp.
>
>

Has your friend done a migration from another system to Oracle ?

Her symptoms sound like the standard problem of a large data transfer introducing a physical distribution that does not match the ongoing daily loading.

---
Jonathan Lewis
ora_mail_at_jlcomp.demon.co.uk
Received on Fri Nov 29 1996 - 00:00:00 CET

Original text of this message