Thanks Ian, that was indeed the question, although the other information is useful as well.
if I understand what you are saying correctly, it works but it won't really buy me anything and I might do better controlling the space myself. And while you have had no problems, you've heard negative things about it. I can't afford to have this database not be available so I'll manage them on my own Rachel --- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote: > The question posed was not whether "extent management local" should > be used, but whether automatic segment space management should be > used. > > As this is a data warehouse, I would not expect you to have > transactions trying to change the same block. Assuming you are > loading; that is, inserting data and not doing updates, wouldn't you > try to cram as much data as possible into a block? Seems this could > be done more easily by controlling these parameters yourself > > I've got one system using automatic segment space management without > any problems, however when I posed the same question on using it a > few months ago, the respone which trickled in way highly negative > concerning its usage. > > Ian MacGregor > Stanford Linear Accelerator Center > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Tuesday, September 03, 2002 8:49 AM > To: Multiple recipients of list ORACLE-L > > > 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: MacGregor, Ian A. > 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). __________________________________________________ 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).
