PCTINCREASE and the SYSTEM tablespace

From: Allan Robertson <allan.robertson_at_morse.com>
Date: Tue, 12 Sep 2000 18:11:50 +0100
Message-Id: <10617.116735@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0001_01C01CE4.EBFE80E0
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I have just started in my new place of work and we were discussing the pctincrease/smon/coalesce issue for tablespaces. The new place prefers to have pctincrease=0 and coalesce via a cron cobtrooled script. Fair enough ...

We then came to discuss the pctincrease value for the system TS. I have always left it at 50% for new sys object creation. At my new place they build the data dict/apps etc then set it to 0%.

I am getting mixed input from books, web sites and metalink on setting the value of pctincrease on the system TS, (including Steve Adams site & his custonizing sql.bsq doc). This is probably the wrong question to ask of a group of DBAs but ...... does anyone have any view on the subject?

Thanks

Allan

---

Allan Robertson
DBA
Morse Business Applications

Switch 	: 0131 338 6060
Fax 	: 0131 338 6061
Email	: allan.robertson_at_morse.com

This email and any attachments are confidential and are intended only for the addressee. If you are not the
intended recipient of this email and have received it in error, please notify the sender immediately by
reply email and then delete it from your system.

Orders are accepted subject to Morse's January 2000 terms and conditions. Copies are available at www.morse.com <http://www.morse.com> and on request.

---

------=_NextPart_000_0001_01C01CE4.EBFE80E0
Content-Type: application/ms-tnef;

        name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;

        filename="winmail.dat"

eJ8+IjIRAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCQAMABIACwAAAAIACwEB A5AGABAJAAAnAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAJgAAAFBDVElOQ1JFQVNFIGFuZCB0aGUgU1lTVEVNIHRhYmxlc3BhY2UAAAACAXEAAQAAABYA AAABwBzcigwxEtpPiMYR1J5FAADoe9++AAACAR0MAQAAAB8AAABTTVRQOkFMTEFOLlJPQkVSVFNP TkBNT1JTRS5DT00AAAsAAQ4AAAAAQAAGDgBqMmzcHMABAgEKDgEAAAAYAAAAAAAAANoq7TJ9WdQR nhUAAOh7377CgAAACwAfDgEAAAADAAYQi9mQ9QMABxCCBAAAHgAIEAEAAABlAAAASUhBVkVKVVNU U1RBUlRFRElOTVlORVdQTEFDRU9GV09SS0FORFdFV0VSRURJU0NVU1NJTkdUSEVQQ1RJTkNSRUFT RS9TTU9OL0NPQUxFU0NFSVNTVUVGT1JUQUJMRVNQQUNFUwAAAAACAQkQAQAAAJsEAACXBAAARgcA AExaRnXEoQUUAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzOdAfcgAqQD4wIAY2gKwOBzZXQwIAcTAoMA UA8D1RGIDlAQdnBycTJNEXZ9CoAIyCA7CW8wNRWfZQ4wNQKACoF1Y6MAUAsDdWxuAiBlC6YIIEkg EQB2ZSBqXHVzBUAacArAdAmAIOELgCBteSAZMAfgC1FCYxowb2YgdwWwa3YgAHAbAHcaMBzgFbAg OmQEAGMaYACQDyAgdGJoGjBwY3QLgAUAZZJhETAvcwRgbi8FoN8HQAeQG/EEAQpQIAIQBcAPAZEf kQqwG/BzLiBUPx4hG4gT8AEQBJAEIHRvuxn0Hlk9EWAcoh9ndgcwnxyQJFADYAOgBaBidANg7wbw GvEE9CFARgtwBcAJ8OEIYGdoIC4nkAqiCoTdCoBXGjAeESWBYQeAIrI/HWUeDiTgB0AgJh4hc3np GnBlbSFQUyFAGeUHQPR3YSvwIB+QAYAbEAVA4mEFQDUwJSBDG4Ir4fkcEGJqBZAFQB6iHnACID0n tUEFQBtbHhEbYGJ19wMQGwAeEmQt8CUQHWAeYLAvYXBwBCARQGMopP8RMS2yIsEuMCFACuMoBhng OSkQIGcRQB5xHfBtafJ4GvNwdQVAA1IxwCXw6GtzLBzRYhqQLcAHkfccogeAAZBsC4AcgCVxETH/ NiMeEisEHCEqSiVxK6s30N4oHoEKQB1gHeFTGuAaIZpBMnBtBCA4MiAmGfBPBAAkUBphAiBpeh3S czBxbC5iP6AdUG9j/ik0sSFgPrE+sRPwJbAgodsbYB4SdyVhHfBxClAacP8v4SKyHtA5QRwwJRAJ wAhg4nAcEkRCQQQgMdAFQO8nkSeRQBE4Y3kZISylRYDXJOEH0TumdS8zPyfKIWDnAHA3sCfKQWwP ASfKSk7FCzBjEhIxICpMP01Pv05fT29PkDTVSZMH8WIEkLx0cwIgJ8REISfETQWw/SrRQhpgC4AH kBKRMyA5EO8pAC/SBCEn2VMD8DNwJ3DJDIIgOjSAMTNMEA9gcDggNjBW4DTVJtB471XfVuFMECfE RQDAAxBX1dsHQA8BLkEhUaRABGARIfouBaBtJ8UTQw4gQIQsIP9ZoRyTRjIt8AGQEPAHgAIwxzhx HTEFoG5maQEAAjD/BzFdZB0xC4Aa4BywGvECIONBcStmYWRkFbAEEAng9yxxHDBFkHVeoxkQNEEe IfcnxGBHFbBjBSAIkAIwHBLPHhBc6xoDZHFlaRogGwHvLaEDoASQA2ByN9ALUCqz/2MBBpBBhBEw YIEFwAdwB4DLHWAt8GVBcWJ5J8QVsP8LUBtgXRgoswEAH5A+US3B3zczYoEFwCvkJ7tPCyAigv9e sgDQG/AFMCYiR0QislLz6icEIEoAcHUKwBtgAdD/cXAeAASQPgEkJBywLcBUYv8ntQhQZLFuxSsA AxAgoi3iynd04C5bRyA8S7EOUIcY8BnwAkBwOi8vdOvzS7MY9CA+NMAcoiVxFbDnQkMnsBITMTZb 1hmiT5//e798z33ffhEnxDTZS6IC0RcBQCfTFLEAgVAAAwAQEAAAAAADABEQAAAAAAsAAIAIIAYA AAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwACgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAAD AAWACCAGAAAAAADAAAAAAAAARgAAAABShQAA8BMAAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAAAFSF AAABAAAABAAAADguNQADACaACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAL4AIIAYAAAAA AMAAAAAAAABGAAAAAA6FAAAAAAAAAwAwgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADADKA CCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AQYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAAB AAAAAQAAAAAAAAAeAEKACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgBDgAgg BgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsAxoALIAYAAAAAAMAAAAAAAABGAAAA AACIAAAAAAAACwDIgAsgBgAAAAAAwAAAAAAAAEYAAAAABYgAAAAAAAALANWACCAGAAAAAADAAAAA AAAARgAAAAAGhQAAAAAAAAsA2YAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAAAgH4DwEAAAAQ AAAA2irtMn1Z1BGeFQAA6HvfvgIB+g8BAAAAEAAAANoq7TJ9WdQRnhUAAOh7374CAfsPAQAAAE4A AAAAAAAAOKG7EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4A AABDOlxXSU5OVFxvdXRsb29rLnBzdAAAAAMA/g8FAAAAAwANNP03AAACAX8AAQAAADEAAAAwMDAw MDAwMERBMkFFRDMyN0Q1OUQ0MTE5RTE1MDAwMEU4N0JERkJFRTQ2NTIyMDAAAAAA0jM= Received on Tue Sep 12 2000 - 12:11:50 CDT