| 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: automatic segment space management
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
ian_at_slac.stanford.edu
-----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
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).
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). Received on Tue Sep 03 2002 - 15:33:23 CDT
 |
 |