Re: Calculate additional space needed to reduce percent used on a tablespace
From: David Barbour <david.barbour1_at_gmail.com>
Date: Fri, 22 Aug 2014 16:37:22 -0500
Message-ID: <CAFH+ifeDj-wWyykLdwYqS5uSR4BQuu_uUUrpoS3_Zr1f0Nb33A_at_mail.gmail.com>
.6x=771952
x=771952/.6
x=1286587
Date: Fri, 22 Aug 2014 16:37:22 -0500
Message-ID: <CAFH+ifeDj-wWyykLdwYqS5uSR4BQuu_uUUrpoS3_Zr1f0Nb33A_at_mail.gmail.com>
.6x=771952
x=771952/.6
x=1286587
On Fri, Aug 22, 2014 at 4:12 PM, Sandra Becker <sbecker6925_at_gmail.com> wrote:
> Oracle 11.2 EE
>
> I need to calculate how much additional space is needed on a tablespace to
> reduce the percentage used from 75% to 60%. We have autoextend on for the
> datafiles belonging to this tablespace so the maxsize needs to be taken
> into account.
>
> Current Values:
> Max_blocks = 1,024,000
> Blocks_used = 771,952
> Pct_used = 75.39
>
> Any help is appreciated. Thank you.
> --
> Sandy
> GHX
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 22 2014 - 23:37:22 CEST