Re: Deallocate Unused

From: vidya kalyanaraman <vidya.kalyanaraman_at_oracle.com>
Date: Fri, 20 Feb 2004 15:35:20 +0530
Message-ID: <4035DBE0.10601@oracle.com>

Hi Richard

Thanks for the explanation. But what makes "keep" option more beneficial or more efficient ?
 what do you use normally?

Regards
Vidya

Richard Foote wrote:

>Hi Vidya,
>
>"deallocate unused" will only deallocate extents up to the size specified by
>your initial/minexents storage allocation.
>
>"deallocate unused keep blah" allows you to go below your initial allocation
>although it won't violate uniform extent size (LMT), minimum extent size
>(DMT), etc. limitations.
>
>Cheers
>
>Richard
>----- Original Message -----
>From: "vidya kalyanaraman" <vidya.kalyanaraman_at_oracle.com>
>To: <oracle-l_at_freelists.org>
>Sent: Thursday, February 19, 2004 10:22 PM
>Subject: Deallocate Unused
>
>
>Hi
>While alterering the table to deallocate the extents which are above the
>HWM, we did use the following command.
>alter table <tab> deallocate unused;
> Another DBA here feels that appending the DDL with "KEEP' keyword
>is more beneficial. But he could not give any solid reason for doing so.
>alter table <tab> deallocate unused keep 10M;
>Can any one tell me how these two commands are different and which is
>more efficient?
>Scanned through Metalink, but could not find the correct answer for this
>question.
>Thanks in Advance
>Vidya
>
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_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_at_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_at_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
-----------------------------------------------------------------

Received on Fri Feb 20 2004 - 04:05:20 CST