Re: Reorganize System Tablespace

From: Mikey <mvergaranospamforme_at_ix.netcom.com>
Date: 11 Sep 2002 03:24:23 GMT
Message-ID: <9285C4285mvergaraixnetcomcom@198.99.146.18>

postbus_at_sybrandb.demon.nl (Sybrand Bakker) spray-painted on the wall <konpnuchc076lkevpdjvkrrcnngeu5kprd_at_4ax.com>:

>
>There is only one way to reorganize the system tablespace
>1 full database export
>2 recreate the database
>3 full database import
>
>Hth
>
>
>Sybrand Bakker, Senior Oracle DBA
>

I would add to that to look seriously at SQL.BSQ before you rebuild the database, and increase the initial extent sizes of the objects you listed in your initial post. We have modified every SQL.BSQ file for this purpose since the 8.0 days, where we started using more and more PL/SQL objects.

I forgot once on one of out e-commerce servers and in just creating the database the IDL_UB1$ table blew out to 3500 tiny-sized extents.

HTH,
Mike Received on Tue Sep 10 2002 - 22:24:23 CDT