From: roobaron Newsgroups: comp.databases.oracle.server Subject: Re: Reorganize System Tablespace Date: Tue, 10 Sep 2002 01:20:13 +0000 Organization: dBforums Lines: 24 Sender: roobaron Message-ID: <1795221.1031620813@dbforums.com> References: <7ca2852.0209090108.6f087ca7@posting.google.com> NNTP-Posting-Host: p-740.newsdawg.com User-Agent: dBforums X-Original-NNTP-Posting-Host: ns.spikeball.com X-Original-Trace: 10 Sep 2002 01:22:36 GMT, ns.spikeball.com If you are going to stuff around rebuilding the system tablespace just build a new database and copy the data from the old into the new. Test the new database in parallel. Note: The copy of the data can be either export/import copy via database link moving tablespaces (and datafiles) The problem with SMON is caused by the PCTINCREASE being 0. At what point is a setting of PCTINCREASE to 100 ever valid? That parameter is one of those nasty ones (i can hear the Oracle developers laughing) which provides enough rope to hang one's self and the strangle performance over time. :) Have Fun -- Posted via http://dbforums.com