OraFAQ Forum: Server Administration » calculate used space in a block

Home » RDBMS Server » Server Administration » calculate used space in a block (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

calculate used space in a block [message #531769]

Thu, 17 November 2011 10:19

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,
Is there any way I can calculate percentage of space
used in a block.Eg if a table size is 100 blocks,How Can
I check the percentage of used space in block.

Thanks,
Varun

Report message to a moderator

Re: calculate used space in a block [message #531771 is a reply to message #531769]

Thu, 17 November 2011 10:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

When you start with the wrong question, no matter how good an answer you get, it won't matter very much.

>Is there any way I can calculate percentage of space
why is such a number needed or desirable?

[Updated on: Thu, 17 November 2011 10:42]

Report message to a moderator

Re: calculate used space in a block [message #531772 is a reply to message #531771]

Thu, 17 November 2011 10:52

varunvir
Messages: 389
Registered: November 2007

Senior Member

Since purging 10 million records in a table wont reduce the size
of table,wanted to check the unused space left by purge process
which could be used by Oracle automatic storage management.

Thanks,
Varun

Report message to a moderator