Re: ANALYZE and space in SYSTEM tablespace

From: Jesper Sivertsen <siv_at_pip.dknet.dk>
Date: Tue, 6 Oct 1998 22:49:35 -0000
Message-ID: <6vdvev$j40$1@news.dknet.dk>

You shuld get no space-problems in system, since the space to hold the result of an ANALYSE is already there.
But the operation can take cuite a while ( hours ) depending on the hardware.

Best regards
Jesper Sivertsen

Hasso Bryck wrote in message <01bdf079$d4b6c9e0$8c647ec2_at_wizard>...
>Hi!
>
>I'd like to run ANALYSE ... ESTIMATE on my production DB.
>DB is ca 30GB and largest tables ca 13-14 milj. records.
>I think some queries will be quite happy if optimizer has
>some info from periodic dbms_utility.analyze_* jobs.
>The problem is that i have no idea how much space
>analyze needs in SYSTEM tablespace. Currently I have
>50MB SYSTEM tablespace and storage options are
>Oracle 7.3.3's defaults. Probably not enough and
>there will be some serious complications (running
>out of extents and so on...)
>Has anybody perfomed full database analyze on
>such 20-30GB DB?
>And are there any hints i should know before
>starting ANALYZE... ESTIMATE on my DB?
>
>--
>Hasso Bryck
>tech. consult
>Korel SYS Ltd.
Received on Tue Oct 06 1998 - 17:49:35 CDT