Oracle-L: Re: Is it possible to define SYSTEM storage parameter from the begining?

From: <Brian_P_MacLean_at_efunds.com>
Date: Wed, 07 Aug 2002 16:18:25 -0800
Message-ID: <F001.004AE509.20020807161825@fatcity.com>

You will find the SYSTEM tablespace and a whole lot more in $ORACLE_HOME/rdbms/admin/sql.bsq. This script is, at least at one time it was, run by Oracle as part of the "create database" command. I have an old posting on Google Groups from 1996 about it:

http://groups.google.com/groups?q=brian.maclean+oracle&hl=en&lr =&ie=UTF-8&oe=UTF-8&safe=off&selm=4d16sn%244bp%40madison.tdsnet.com&rnum=20

I haven't messed with modifying this file since oracle v7.1.3 but it should still work. I used to play with the initial extent value for a few tables like obj$, objauth$, objpriv$, source$, and a few others.

Maybe a search on MetaLink for sql.bsq is also in order.

Let me know what happens

                                                                                                                               
                      Jonny Delmont                                                                                            
                      <jonny99delmont_at_y        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>           
                      ahoo.co.uk>              cc:                                                                             
                      Sent by:                 Subject:  Is it possible to define SYSTEM storage parameter from the begining?  
                      root_at_fatcity.com                                                                                         
                                                                                                                               
                                                                                                                               
                      08/07/02 09:15 AM                                                                                        
                      Please respond to                                                                                        
                      ORACLE-L

Dear all,

I've seen many databases with pct_increase = 50% as default on system tablespace... Why? is there any reason?
Is it possible to define storage parameter on SYSTEM tablespace from the begining. If so what is the possible syntax please?

Thanks,
Jonny

Get a bigger mailbox -- choose a size that fits your needs.

http://uk.docs.yahoo.com/mail_storage.html

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Brian_P_MacLean_at_eFunds.Com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 07 2002 - 19:18:25 CDT