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).
Received on Fri Jun 13 2003 - 08:37:55 CDT
