Re: Temp space used by ANALYZE command

From: Naren Chintala <naren_at_mink.att.com>
Date: 1997/02/28
Message-ID: <33171F2E.75FE@mink.att.com>#1/1

Hi,

I did ask Oracle Support about this. Got no answer. I gather from the Advanced Tuning book (from Oracle Press) that the the analyze command would take temporary space that is 4 times the size of the table.

Hope this helps.

Naren

> John Bechtel <john.bechtel_at_teldta.com> wrote in article
> <33160E52.2B88_at_teldta.com>...
> > I'm looking for any information about how much temp space is used during
> > an ANALYZE TABLE command. I would like to run many simultaneous ANALYZE
> > commands, but fear I will run out of temp space if several large tables
> > are being analyzed at the same time.
> >
> > Any/all information will be helpful and appreciated.
> >
> > - John Bechtel
> >
Received on Fri Feb 28 1997 - 00:00:00 CST