Re: Calculate additional space needed to reduce percent used on a tablespace
Date: Sun, 24 Aug 2014 00:06:19 -0400
Message-ID: <CAEgY-F6HB_3em=KyGm=VUNGtV3qdt+7cN=-0PsLe+4o7WMQ+kg_at_mail.gmail.com>
David's calculation gives you the new total you want.
That is, what is the number when 60% of the number is 771,952? (See David's calculation).
Now you know the old total blocks and new total blocks. The difference
(1,286,587-1,024,000) is the number of blocks you need to add, either by
allowing current file(s) to get larger, or adding a new file of that size
(262,587 blocks). Hint: for this last step you probably need to know the
block size!
Cheers, Wayne
On Aug 22, 2014 5:39 PM, "David Barbour" <david.barbour1_at_gmail.com> wrote:
> .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 Sun Aug 24 2014 - 06:06:19 CEST