Home » RDBMS Server » Server Administration » free space
free space [message #305938] Wed, 12 March 2008 06:30 Go to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Hi all,

How to calculate the maximum free space chunks from the dba_free_space table

Report message to a moderator

Re: free space [message #305941 is a reply to message #305938] Wed, 12 March 2008 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Using the MAX function on blocks?

Regards
Michel

[Updated on: Wed, 12 March 2008 06:33]

Report message to a moderator

Re: free space [message #305944 is a reply to message #305941] Wed, 12 March 2008 06:37 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Michel !

How we can conclude that one or more tablespaces have fragmented free space ?

Report message to a moderator

Re: free space [message #305947 is a reply to message #305944] Wed, 12 March 2008 06:43 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
LMT are never fragmented.

Regards
Michel

Report message to a moderator

Previous Topic: ACL denied using Pkb but works using anonymous block with same user
Next Topic: cannot able to open the database with startup option
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 03:43:01 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.