Re: Calculate additional space needed to reduce percent used on a tablespace
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: sbecker6925@xxxxxxxxx
- Date: Fri, 22 Aug 2014 16:37:22 -0500
.6x=771952
x=771952/.6
x=1286587
On Fri, Aug 22, 2014 at 4:12 PM, Sandra Becker <sbecker6925@xxxxxxxxx>
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
>
Other related posts:
