Re: Deallocate Unused
- From: vidya kalyanaraman <vidya.kalyanaraman@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Feb 2004 15:35:20 +0530
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@xxxxxxxxxx>
>To: <oracle-l@xxxxxxxxxxxxx>
>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@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:
