One note: 9i automatic segment space management does not automate PCTFREE; that still functions as before. It does cause PCTUSED, FREELISTS, and FREELIST GROUPS to be ignored, however...
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 03, 2002 9:48 AM > time for me to ask the experts again. > > My data warehouse will be 9.2, with all locally managed tablespaces. We > will be following what I have taken to calling the "Goldilocks" > principle -- that of small, medium and large tablespace extent sizes, > with variations in that we will separate indexes and data, and will > have even more separation for our fact tables into partitioned tables > and tablespaces. > > However, now comes the time for me to work out storage clauses. And a > quick read through the docs leaves me wondering if I should just turn > on automatic segment-space management and not worry about setting > PCTFREE, PCTUSED and FREELIST parameters. I can't find any real > information or bugs on MetaLink either. > > Does anyone have any experience, good OR bad, with using this feature? > If you are doing data warehouse work, what are good values for the > parameters if I DO use them? One fact table is likely to be highly > updated (customer info) as we collect more and more specific > information from customers. The rest will be, as you would expect from > a DW, mostly inserts. > > Help? > > Thanks! > > Rachel > > __________________________________________________ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
