RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ?

  • From: "Mohan, Ross" <RMohan@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Jul 2004 09:30:16 -0400

Mark, 
Thanks. 

....well...a drop/resurrect.....to change the extent size to 
something I want, yes. (i.e. something smaller) 

Apparently if the new/requested extent size is "a factor" of the 
minimum already-used extent size in the tspace, I can change it
but that implies only upward extent size growth. not what I had
in mind. 

Also, the FMs are a tad opaque on this issue. They refer to 
something called an "allocation_unit" (which I think may
really be blocks, but the only specific I was able to dig
up in one place said it was in bytes. Go figure.) and the
process for figuring out the allowable extent size modifications
rivals Andrew Wile's proof of Fermat's Last Theorem, involving
Greatest Common Divisors of Multiple Factors in Minimum Spanning
Spaces over a Field of Binary Integers Maximized in a Bitmap. 

Kind of like a title to an early, early Pink Floyd song. 
( Two somethings Groovin' in a Cave with a Pict or somesuch) 



Anyway, back to Oracle. (God, this is exciting.) 


-----Original Message-----
From: Powell, Mark D [mailto:mark.powell@xxxxxxx] 
Sent: Wednesday, July 21, 2004 8:16 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=>
LMTS ?


No, you are not wrong.  You need to drop and recreate a tablespace to change
the uniform extent size.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Mohan, Ross
Sent: Tuesday, July 20, 2004 7:21 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Slick tricks for extent size reduction in LMTS via LMTS=>DM=>LMTS ?


I am gathering, painfully, that once you create and
partially populate a half terabyte tspace with local
ext mgmt extent size 100M there's no way to reduce
the extent size to, say, 5M. 
Please someone tell me I am wrong.


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: