RE: pctincrease --SYS objects

Jack,

I agree with you 100%! Just because someone asks you how to hang himself doesn't mean you're obligated to tie the noose for him!

Just my $.02

• Anita
  • Jack Silvey <JSilvey_at_XOL.com> wrote:
    > Steve,
    >
    > Come over here and let me speak with you in
    > private....
    >
    > Do you really want to advise people to start editing
    > the sql.bsq file if
    > they don't know whether or not they can change data
    > dictionary defaults?
    >
    > Don't you think that if they are asking the question
    > then the answer for
    > them (at that level of experience) is a hale and
    > hearty NO?
    >
    > What's next, indexes on the data dictionary?
    > Analyzing the sys schema? DOGS
    > AND CATS LIVING TOGETHER?
    >
    > To quote from "Bridge Over the River Quai":
    > "Madness! Madness!"
    >
    > Once they reach the level of experience where they
    > know what doing things
    > like changing the DD defaults means, then they will
    > also know whether or not
    > it is a good idea and why.
    >
    > Until they know, just say no!
    >
    > Just call it the zen philosophy of being an Oracle
    > DBA.
    >
    >
    > Jack Silvey
    > ocp x 2
    > senior @ xol.com
    >
    >
    >
    > -----Original Message-----
    > Sent: Friday, June 30, 2000 12:04 PM
    > To: Multiple recipients of list ORACLE-L
    >
    >
    > ricochet...
    >
    > Ah, but it is "broken" or will become broken if you
    > use it much. "Broken"
    > being defined as poor space management and
    > performance hindering
    > fragmentation.
    >
    > Do experienced DBA's accept the all the Oracle
    > defaults for DB creation? Of
    > course not so why accept the defaults within the
    > data dictionary? Have
    > courage, be a man, or goddess, and copy the sql.bsq
    > to
    > $ORACLE_BASE/admin/<SID>/create and edit it to set
    > the proper storage
    > clauses.
    >
    > Set the following in your init<SID>.ora file (for
    > db_creation only):
    >
    > _init_sql_file =
    > /PathToOracleBase/admin/<SID>/create/sql.bsq
    >
    > Then choose a healthy db_block_size and create your
    > database. Then set the
    > system tablespace defaults to something like the
    > following:
    >
    > ALTER TABLESPACE SYSTEM
    > DEFAULT STORAGE ( INITIAL 64K MINEXTENTS 1
    > MAXEXTENTS 4096
    > PCTINCREASE 100) ;
    > ALTER TABLESPACE SYSTEM MINIMUM EXTENT 64K ;
    >
    > Then create the rest of your tablespaces and
    > rollback segments and install
    > any Oracle supplied packages. OK, you may want to
    > think about that
    > PCTINCREASE 100 setting. But don't get crazy and
    > make system a locally
    > managed tablespace. Wait for Oracle on this one.
    >
    > Need more encouragement? See Steve Adam's
    > "Customizing SQL.BSQ" web page:
    > http://www.ixora.com.au/tips/creation/bsq.htm
    >
    >
    > Be thou of good courage. Shrink not from thine
    > appointed destiny. Seek and
    > ye shall find, ask and it shall be given thee, knock
    > and it shall be opened
    > to thee. Take heart, the Oracle is with thee.
    >
    >
    > Steve Orr
    >
    >
    > -----Original Message-----
    > Sequeira
    > Sent: Friday, June 30, 2000 12:36 AM
    > To: Multiple recipients of list ORACLE-L
    >
    >
    > Or, 'If ain't broke, don't fix it'
    >
    > --
    > S. Anthony Sequeira
    >
    > Wait for the ricochet
    >
    > Opinions expressed herein are my own and do
    > not necessarily represent those of my employer
    > ----- Original Message -----
    > To: Multiple recipients of list ORACLE-L
    > <ORACLE-L_at_fatcity.com>
    > Sent: 29 June 2000 22:25
    >
    >
    > > At 12:09 PM 6/29/00 -0800, you wrote:
    > > >domain? Knowest thy not the meaning oft the adage
    > "Leave well enough
    > alone?"
    > > >
    > >
    > > Or, in the modern vernacular: "You f**k with that,
    > you're on your
    > own!"
    > > ---
    > > Dennis Taylor
    > > ---
    > > The opinions expressed herein are mine. Get your
    > own opinions!
    > > ---
    > > --
    > > Author: I.S. Manager
    > > INET: ismgr_at_pctc.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).
    > >
    >
    >
    > --
    > Author: S. Anthony Sequeira
    > INET: Sequeira_at_lineone.net
    >
    > 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).
    >
    > --
    > Author: Steve Orr
    > INET: sorr_at_arzoo.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).
    > --
    > Author: Jack Silvey
    > INET: JSilvey_at_XOL.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