Re: default storage for SYSTEM tablespace

In article <86ni9v$phg$1_at_nnrp1.deja.com>, edstevens_at_my-deja.com wrote:
> When we create a new database, the SYSTEM tablespace is created
> with a
> pctincrease of 50%. All recommendations say that tablespaces and
> tables should be have a pctincrease of 0. This is no problem for
> objects we create, but how do we control this for SYSTEM
> tablespace at
> DB creation time?
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Your reference to "all recommendations" must not have really included ALL recommendations. First of all, you can alter the sql.bsq if you feel it is really necessary to do this on database creation; or you can just ALTER the pctincrease parameter for the SYSTEM tablespace after creation if you simply can't resist changing it. It really should be left alone. As far as your statement about other tablespaces and tables, if you set all tablespaces to pctincrease 0 you will not be receiving the benefits of the SMON coalescing your tablespaces. I agree that tables and indexes should definitely have a pctincrease of 0, but all tablespaces EXCEPT Rollback, Temporary and System, should have a default storage pctincrease of 1 so that SMON will automatically coalesce them. Since the Rollback and Temporary tablespaces should have the pctincrease set to 0, we schedule a job that runs at inactive times to coalesce the Rollback and Temporary tablespaces.

hth

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!