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
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: 64145
Registered: March 2007
Location: Nanterre, France, http://...
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 ?
Re: free space [message #305947 is a reply to message #305944] Wed, 12 March 2008 06:43 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LMT are never fragmented.

Regards
Michel
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:
  


Current Time: Fri Dec 09 12:05:23 CST 2016

Total time taken to generate the page: 0.07525 seconds