Home » RDBMS Server » Server Administration » how to know which block contains free space? (oracle 10g r2 64bit,windows,linux)
how to know which block contains free space? [message #578317] Tue, 26 February 2013 22:07 Go to next message
lzfhope
Messages: 64
Registered: July 2006
Member
hi,all
for some reason,i want to know which data block contains free space,or which table/index contains free space.
thanks in advance!
Re: how to know which block contains free space? [message #578319 is a reply to message #578317] Tue, 26 February 2013 22:30 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
>,i want to know which data block contains free space,or which table/index contains free space.

query DBA_FREE_SPACE for desired details
Re: how to know which block contains free space? [message #578327 is a reply to message #578317] Wed, 27 February 2013 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You can have a look at the following script: Get the allocation map of tablespaces.

2/ See DBMS_SPACE package (especially SPACE_USAGE and UNUSED_SPACE procedures)

Regards
Michel
Re: how to know which block contains free space? [message #578328 is a reply to message #578327] Wed, 27 February 2013 00:44 Go to previous messageGo to next message
lzfhope
Messages: 64
Registered: July 2006
Member
Thank black swan and Michel Cadot!
Re: how to know which block contains free space? [message #578422 is a reply to message #578317] Wed, 27 February 2013 21:29 Go to previous messageGo to next message
GirishSharma
Messages: 22
Registered: March 2010
Junior Member
Can you please share those some reasons (what exact business need) for you want to know the addresses of blocks which contains the free space ? Its oracle internal algorithm and it works under the cover that which block should be picked up to satisfy insert/update for good space allocation.

Regards
Girish Sharma
Re: how to know which block contains free space? [message #578680 is a reply to message #578422] Sun, 03 March 2013 20:17 Go to previous messageGo to next message
lzfhope
Messages: 64
Registered: July 2006
Member
Yeah,in fact, no business need now.what you said is reasonable.
I just want to know the core algorithm,but now is seems that is not possible to know that.
Re: how to know which block contains free space? [message #578682 is a reply to message #578680] Mon, 04 March 2013 00:44 Go to previous message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
,but now is seems that is not possible to know that.


You didn't ask for this question, so we didn't answer to this one.
You want to know core algorithm for what exactly?

Regards
Michel
Previous Topic: unable to connect to database
Next Topic: ASM instance
Goto Forum:
  


Current Time: Wed Sep 17 15:08:25 CDT 2014

Total time taken to generate the page: 0.24132 seconds