there was a debate on here 2 weeks ago where it was concluded that until you get to thousands of extents it just doesnt matter how many you have. > > From: "VIVEK_SHARMA" <[EMAIL PROTECTED]> > Date: 2003/06/13 Fri AM 06:39:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Fragmentation ? > > Dennis , List > > What may be the OTHER forms of fragmentation ? > > What Number of Extents may be considered Critical warranting RE-Organization for > Manually Sized Objects existing in LMTs ? > > Thanks for the great paper . Had read it previously though . > > Thanks > > > -----Original Message----- > Sent: Wednesday, June 11, 2003 8:25 PM > To: Multiple recipients of list ORACLE-L > > > Vivek > Make sure you've read "How to Stop Defragmenting and Start Living" > http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049 > The authors point out that uniform extents stop fragmentation at the > tablespace level. However they point out that there are other forms of > fragmentation. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Wednesday, June 11, 2003 9:15 AM > To: Multiple recipients of list ORACLE-L > > > > Qs What is the advantage of having dba_tablespaces.ALLOCATION_TYPE = > "UNIFORM" OVER dba_tablespaces.ALLOCATION_TYPE = "USER" ? > > With ALLOCATION_TYPE = "UNIFORM" , NEXT_EXTENT Size of the Object can NOT be > Manually defined in the Table Creation Script <storage (NEXT <Value>)> , > which is allowed when having allocation_type="USER" . > > Allocation_type="USER" allows Objects with Different NEXT_EXTENT Sizes to be Created > in the SAME LOCALLY managed Tablespace & thus reduces Total Number of Extents for > the respective Table. Our Application does have Objects of Dissimilar Sizes > Existing tin the Same Tablespace . > > Does ALLOCATION_TYPE = "UNIFORM" automatically imply NO Fragmentation > Irrespective of the Number of Extents of the Object (in a Locally Managed > Tablespace) ? Does it further imply NO further need to Look at Number of > Extents of an Object in a Locally Managed Tablespace ? > > NOTE Allocation_type can be made = "USER" by using the stored procedures :- > dbms_space_admin.tablespace_migrate_from_local / > dbms_space_admin.tablespace_migrate_to_local > > Am i still Lost in the World of Oracle 7 ? > > Thanks > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
