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: 214
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.

Report message to a moderator

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: 26766
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.

Report message to a moderator

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

Report message to a moderator

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: 4963
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?

Report message to a moderator

Previous Topic: How to enable Java in Oracle 8.1.7?
Next Topic: Oracle licenses
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:44:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.