OraFAQ Forum: Server Administration » how to know which block contains free space?

Home » RDBMS Server » Server Administration » how to know which block contains free space? (oracle 10g r2 64bit,windows,linux)

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

how to know which block contains free space? [message #578317]

Tue, 26 February 2013 22:07

lzfhope
Messages: 69
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!

Report message to a moderator

Re: how to know which block contains free space? [message #578319 is a reply to message #578317]

Tue, 26 February 2013 22:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: how to know which block contains free space? [message #578327 is a reply to message #578317]

Wed, 27 February 2013 00:39

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: how to know which block contains free space? [message #578328 is a reply to message #578327]

Wed, 27 February 2013 00:44

lzfhope
Messages: 69
Registered: July 2006

Member

Thank black swan and Michel Cadot!

Report message to a moderator

Re: how to know which block contains free space? [message #578422 is a reply to message #578317]

Wed, 27 February 2013 21:29

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

Report message to a moderator

Re: how to know which block contains free space? [message #578680 is a reply to message #578422]

Sun, 03 March 2013 20:17

lzfhope
Messages: 69
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.

Report message to a moderator

Re: how to know which block contains free space? [message #578682 is a reply to message #578680]

Mon, 04 March 2013 00:44

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	unable to connect to database
Next Topic:	ASM instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 23:32:47 CST 2025