Home » RDBMS Server » Server Administration » High Number of Free chunks
High Number of Free chunks [message #224908] Thu, 15 March 2007 22:21 Go to next message
kumarvk
Messages: 211
Registered: July 2004
Senior Member
Hi,

Can anyone help me how to remove this high number of free chunks in my tablespaces? Please help me with step by step method.
Re: High Number of Free chunks [message #224910 is a reply to message #224908] Thu, 15 March 2007 22:29 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Can anyone help me how to remove this high number of free chunks in my tablespaces?
They are NOT a problem. Ignore them.
Re: High Number of Free chunks [message #225026 is a reply to message #224908] Fri, 16 March 2007 11:10 Go to previous messageGo to next message
jamesbond007
Messages: 2
Registered: August 2006
Junior Member
Hi, you need to execute the following command
alter tablespace <tablespace_name> coalesce;
it will work
Re: High Number of Free chunks [message #225032 is a reply to message #225026] Fri, 16 March 2007 11:56 Go to previous message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
jamesbond007 wrote on Fri, 16 March 2007 12:10
Hi, you need to execute the following command
alter tablespace <tablespace_name> coalesce;
it will work


Another one living in the past when dictionary managed tablespaces were the norm. Coalescing a locally managed tablespace is pointless. And please tell me why you think you need to eliminate free chunks?
Previous Topic: How to enable Java in Oracle 8.1.7?
Next Topic: Oracle licenses
Goto Forum:
  


Current Time: Thu Dec 08 18:44:14 CST 2016

Total time taken to generate the page: 0.11818 seconds