ANALYZE and space in SYSTEM tablespace

From: Hasso Bryck <hasso_at_korel.ee>
Date: 5 Oct 1998 15:59:38 GMT
Message-ID: <01bdf079$d4b6c9e0$8c647ec2@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 Mon Oct 05 1998 - 10:59:38 CDT