Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ANALYZE and space in SYSTEM tablespace
Hi,
Analyze can take a lot of space in the temporary tablespace of the user that's executing as well. I recently had to enlarge the temp tablespace to 750 Mb. We're using analyze compute statistics once a week on 14 Gb database.
Jeroen
On 5 Oct 1998 15:59:38 GMT, "Hasso Bryck" <hasso_at_korel.ee> wrote:
>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 Sat Oct 10 1998 - 09:04:34 CDT