Re: In 10g, Identifying Tables for Reorg and Compression
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Mon, 20 Sep 2010 10:14:18 -0700 (PDT)
Message-ID: <e3adce84-043d-438b-b424-acebe3db2a5e_at_q21g2000prm.googlegroups.com>
On Sep 17, 2:32 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> Hi,
>
> I checked google, but did not find much on identifying tables
> in 10g that can benefit (In terms of space reduction)
> from reorganization, or from compression. (I realize that
> there are many considerations for reorg and compression,
> but I am looking for a starting point).
>
> Any ideas would be appreciated.
>
> Thanks,
> QZ
Date: Mon, 20 Sep 2010 10:14:18 -0700 (PDT)
Message-ID: <e3adce84-043d-438b-b424-acebe3db2a5e_at_q21g2000prm.googlegroups.com>
On Sep 17, 2:32 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> Hi,
>
> I checked google, but did not find much on identifying tables
> in 10g that can benefit (In terms of space reduction)
> from reorganization, or from compression. (I realize that
> there are many considerations for reorg and compression,
> but I am looking for a starting point).
>
> Any ideas would be appreciated.
>
> Thanks,
> QZ
Google tom kyte show_space for a procedure that nicely formats the output of the dbms_space packaged procedures. Received on Mon Sep 20 2010 - 12:14:18 CDT