RE: Extent allocation for objects

Hi Lisa!!

My co-worker really likes the concept of SYSTEM allocation for LMTs. I guess I was a UNIFORM size BIGOT before as a carry over of that was how we had to manually do it when all we had was dictionary managed tablespaces. He has convinced me to reconsider my opinion of SYSTEM vs UNIFORM. I am no longer going to blindly use UNIFORM, but consider both when we rebuild / migrate our system to the mainframe.

• Babette

-----Original Message-----
Sent: Tuesday, May 20, 2003 9:22 AM
To: Multiple recipients of list ORACLE-L

Am I the only one who praises locally managed tablespaces with SYSTEM allocation?? Or am I the only one who is really tight on disk space? I started with UNIFORM allocation, thinking "I know better than to let Oracle handle it" and I realize now that system allocation saves me space.

Just my two cents

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax: 954-935-3639
Cell: 954-683-4459

-----Original Message-----
Sent: Monday, May 19, 2003 5:58 PM
To: Multiple recipients of list ORACLE-L

It's a characteristic of uniform size. If you have uniform size 512 M, then you can't have an extent that is any other size. So you can specify initial extent and next extent until you're blue in the face, but you will always get 512 M extent sizes. See? Maybe LMT is quite the grand panacea.

> -----Original Message-----
>
> Let me give you the scenarios. Maybe I can get a good
> explanation from
> someone.
>
> Tablespace A locally managed uniform extents size 512M.
> Tablespace B locally managed uniforma extents size 1M.
>
> 1) Create table TabA tablespace A. Insert data, and it has 1
> extent of
> 512M even though the table size is only 76M. This makes sense.
> 2) Create table TabA tablespace B. Insert data, and it has
> 76 extents of
> 1M each. This makes sense.
> 3) Create table TabA tablespace A. Same as scenario 1. Alter
> table TabA
> move tablespace B. Creates 512 extents of 1M each. Why?
> The table only needs 76M of space. Why create all those
> additional
> extents?
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

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: 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Koivu, Lisa
  INET: Lisa.Koivu_at_Fairfieldresorts.com

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: 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Babette Turner-Underwood
  INET: babette_at_rogers.com

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: 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).