Re: Shrink Table: IEstimating Rollback Space
From: Ian MacGregor <ian_at_slac.stanford.edu>
Date: Fri, 17 Oct 2008 08:22:19 -0700
Message-ID: <C51DFBBB.1251A%ian@slac.stanford.edu>
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
> "A 'No' uttered from the deepest conviction is better than a 'Yes'
> merely uttered to please, or worse, to avoid trouble."
> Mohandas Gandhi Quotes
> : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
>
Date: Fri, 17 Oct 2008 08:22:19 -0700
Message-ID: <C51DFBBB.1251A%ian@slac.stanford.edu>
Thanks for the pointer. I was planning on shrinking the indexes separately.
It doesn't look like the shrink will be possible.
Ian
On 10/17/08 7:47 AM, "Hemant K Chitale" <hkchital_at_singnet.com.sg> wrote:
>
> Undo (and Redo !) will be quite noticeable-- more so as you have
> indexes on the table.
>
> A SHRINK operates as a DELETE (which will be the very significant
> portion of Undo) *and* an INSERT.
> Both operations also have to update Indexes .
> The Indexes will not shrink until and unless you do a COALESCE or REBUILD.
>
> See MetaLink Note#577375.1 and Bug# 3888229.
>
> Hemant K Chitale
>
> At 04:52 AM Friday, Ian MacGregor wrote:
>> I have a 450 GB table with 150 GB of free space. I'd like to shrink the >> table, but I'm not sure how much rollback will be needed. Is there a >> formula? One that accounts for the indexes as well? >> >> Ian MacGregor >> SLAC National Accelerator Laboratory >> >> -- >> http://www.freelists.org/webpage/oracle-l
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
> "A 'No' uttered from the deepest conviction is better than a 'Yes'
> merely uttered to please, or worse, to avoid trouble."
> Mohandas Gandhi Quotes
> : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 17 2008 - 10:22:19 CDT