Re: Oracle 8i - defrag SYSTEM tablespace how?

Oracle 8i Tuning Manual, p20-33

<quote>

Modifying the SQL.BSQ File

    The SQL.BSQ file runs when you issue the CREATE DATABASE     statement. Thisfile contains the table definitions that make up the     Oracle server. The views you use as a DBA are based on these tables.     Oracle recommends that you strictly limit modifications to SQL.BSQ.

        If necessary, you can increase the value of the following storage
        parameters:
        INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, PCTINCREASE, FREELISTS,
        FREELIST GROUPS, and OPTIMAL.

        With the exception of PCTINCREASE, do not decrease the setting of a
        storage parameter to a value below the default. (If the value of
        MAXEXTENTS is large, you can lower the value for PCTINCREASE or
        even set it to zero.)

        No other changes to SQL.BSQ are supported. In particular, you should
        not add, drop, or rename a column.

<end quote>

Of course the impact of the above is spoiled by the note in the readme.doc which gives the usual:

    'mess with me and you're dead'

warning about sql.bsq.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

michael_bialik_at_my-deja.com wrote in message <81un4e$28s$1_at_nnrp1.deja.com>...
>Hi.
>
> It's very nice to advice "change bsq file", but my tech support said
> that Oracle can not be responsible for my db if ANYTHING happens
> afterward.
>
> Michael.
>
Received on Thu Dec 02 1999 - 06:33:32 CST