From oracle-l-bounce@freelists.org Wed Jul 21 10:54:00 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6LFrjo23366 for ; Wed, 21 Jul 2004 10:53:55 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6LFrZ623333 for ; Wed, 21 Jul 2004 10:53:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0FC6B72D0F8; Wed, 21 Jul 2004 10:29:13 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13574-04; Wed, 21 Jul 2004 10:29:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 72D8472E0C1; Wed, 21 Jul 2004 10:25:53 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 21 Jul 2004 10:23:43 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B839272CED2 for ; Wed, 21 Jul 2004 10:19:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09696-81 for ; Wed, 21 Jul 2004 10:19:48 -0500 (EST) Received: from imail01.thexchange.com (imail.arbinet.com [64.74.47.121]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3B53172C80B for ; Wed, 21 Jul 2004 10:17:02 -0500 (EST) Received: from imail01.thexchange.com (localhost [127.0.0.1]) by imail01.thexchange.com (8.12.10/8.12.2) with ESMTP id i6LFhhZB011908 for ; Wed, 21 Jul 2004 15:43:43 GMT Received: from postoffice.arbinet.com (mailbox.arbinet.com [64.74.47.120]) by imail01.thexchange.com (8.12.2/8.12.2) with ESMTP id i6LFhhrO011905 for ; Wed, 21 Jul 2004 15:43:43 GMT Received: by postoffice.thexchange.com with Internet Mail Service (5.5.2656.59) id <3CM4R8KW>; Wed, 21 Jul 2004 11:43:46 -0400 Message-ID: From: "Mohan, Ross" Subject: RE: Slick tricks for extent size reduction in LMTS via LMTS=>DM=> LMTS ? Date: Wed, 21 Jul 2004 11:42:45 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-type: text/plain To: X-Spam-Details: Hits=-4.8, Required=2, Tests=BAYES_00,HTML_MESSAGE X-Scanned-By: MIMEDefang 2.39 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5620 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: RMohan@arbinet.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@LIFETOUCH.COM] Sent: Wednesday, July 21, 2004 10:03 AM To: 'oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mohan, Ross Sent: Wednesday, July 21, 2004 8:30 AM To: oracle-l@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@eds.com] Sent: Wednesday, July 21, 2004 8:16 AM To: 'oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mohan, Ross Sent: Tuesday, July 20, 2004 7:21 PM To: oracle-l@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. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------