Home » RDBMS Server » Server Administration » calculate used space in a block (10.2.0.4)
calculate used space in a block [message #531769] Thu, 17 November 2011 10:19 Go to next message
varunvir
Messages: 323
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
Re: calculate used space in a block [message #531771 is a reply to message #531769] Thu, 17 November 2011 10:31 Go to previous messageGo to next message
BlackSwan
Messages: 21948
Registered: January 2009
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 Go to previous messageGo to next message
varunvir
Messages: 323
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
Re: calculate used space in a block [message #531774 is a reply to message #531772] Thu, 17 November 2011 10:58 Go to previous messageGo to next message
BlackSwan
Messages: 21948
Registered: January 2009
Senior Member
assuming statistics are current query USER_TABLES.FREE_BLOCKS
Re: calculate used space in a block [message #531779 is a reply to message #531774] Thu, 17 November 2011 11:12 Go to previous messageGo to next message
John Watson
Messages: 4082
Registered: January 2010
Location: Global Village
Senior Member

Quote:
assuming statistics are current query USER_TABLES.FREE_BLOCKS

Also AVG_SPACE
Re: calculate used space in a block [message #531786 is a reply to message #531769] Thu, 17 November 2011 11:20 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use DBMS_SPACE_ADMIN package.

Regards
Michel
Re: calculate used space in a block [message #531817 is a reply to message #531769] Thu, 17 November 2011 16:27 Go to previous message
varunvir
Messages: 323
Registered: November 2007
Senior Member
Thanks a lot Experts!!
Previous Topic: 10g change disk with datafiles
Next Topic: Maximum concurrent logins
Goto Forum:
  


Current Time: Sat Apr 19 12:34:31 CDT 2014

Total time taken to generate the page: 0.08769 seconds