RE: pctincrease --SYS objects

From: Steve Orr <sorr_at_arzoo.com>
Date: Fri, 30 Jun 2000 08:36:43 -0700
Message-Id: <10544.110944@fatcity.com>

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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of S. Anthony Sequeira
Sent: Friday, June 30, 2000 12:36 AM
To: Multiple recipients of list ORACLE-L Subject: Re: pctincrease --SYS objects

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

Received on Fri Jun 30 2000 - 10:36:43 CDT