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
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.ukReceived on Fri Nov 29 1996 - 00:00:00 CET