Re: Temp space used by ANALYZE command

From: Steve Lemme <rp1399_at_email.sps.mot.com>
Date: 1997/03/06
Message-ID: <rp1399-0603971135230001@m12cim15.sps.mot.com>#1/1

> 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

IF you do not wish to to bulk analyzes by user you can selectively pick objects to nalyze with the PLATINUM Dbvision product. You also get tons of statistics as well

Steve Lemme
DBA
Motorola

-- 
When you are in it up to your ears....
Keep your mouth shut!
rp1399_at_email.sps.mot.com

Received on Thu Mar 06 1997 - 00:00:00 CST