Re: ANALYZE and space in SYSTEM tablespace

On 5 Oct 1998 15:59:38 GMT, "Hasso Bryck" <hasso_at_korel.ee> wrote:

As I understand it, ANALYZE doesn't explicitly require space in the SYSTEM tablespace, just in the user's DEFAULT TABLESPACE.

If you are using ANALYZE as SYS, and the DEFAULT TABLESPACE has not been changed, then this might cause problems...

>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?
Received on Tue Oct 06 1998 - 04:17:38 CDT