| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: pctincrease --SYS objects
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-----
From: Steve Orr [mailto:sorr_at_arzoo.com]
Sent: Friday, June 30, 2000 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: pctincrease --SYS objects
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) ;
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:25Received on Fri Jun 30 2000 - 14:54:10 CDT
> 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
 |
 |