Re: Reorganize System Tablespace

From: roobaron <member_at_dbforums.com>
Date: Tue, 10 Sep 2002 01:20:13 +0000
Message-ID: <1795221.1031620813@dbforums.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

Received on Mon Sep 09 2002 - 20:20:13 CDT