| 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: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ?
Dennis,
Absolutely not.
But the "allocation unit" bit was just poorly presented by me. It's simply a parameter to migrate_to_local the units of which were unclear to me.
thanks
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
Sent: Wednesday, July 21, 2004 10:03 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=>
LMTS ?
Ross - If you found a back door and made the change, would you trust that
tablespace? Personally I don't like worrying whether things like that
returning to bite me at a future time.
Dennis Williams
DBA
Lifetouch, Inc.
Does believing you're the last sane man on the planet make you crazy?
Del Spooner in I Robot, played by Will Smith
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Mohan, Ross
Sent: Wednesday, July 21, 2004 8:30 AM
To: oracle-l_at_freelists.org
Subject: RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=>
LMTS ?
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_at_eds.com]
Sent: Wednesday, July 21, 2004 8:16 AM
To: 'oracle-l_at_freelists.org'
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Mohan, Ross
Sent: Tuesday, July 20, 2004 7:21 PM
To: oracle-l_at_freelists.org
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
 |
 |