OraFAQ Forum: Server Administration » detecting tablespace fragmentation

Home » RDBMS Server » Server Administration » detecting tablespace fragmentation

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

detecting tablespace fragmentation [message #127579]

Tue, 12 July 2005 06:09

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

pls explain me how to detect tablespace fragmentation ?

And method to resolve it.

Report message to a moderator

Re: detecting tablespace fragmentation [message #127587 is a reply to message #127579]

Tue, 12 July 2005 07:35

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Only 9300 results if you search for it on google.

http://www.google.com/search?hl=en&ned=&ie=UTF-8&q=tablespace+fragmentation&btnmeta%3Dsearch%3Dsearch=Search+the+Web

That doesn't even include searching this very site.

[Updated on: Tue, 12 July 2005 07:36]

Report message to a moderator

Re: detecting tablespace fragmentation [message #127589 is a reply to message #127587]

Tue, 12 July 2005 07:44

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

i have already done that bt didnt get the proper answer. Most of the people are telling, hw to resolve fragmentation ?

but i wanted to know hw to check whether a tablespace is fragmented.

Thanx for ur reply

Report message to a moderator

Re: detecting tablespace fragmentation [message #127591 is a reply to message #127579]

Tue, 12 July 2005 07:50

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

OK i got the answer , and i think the issue is over.

Tarun

Report message to a moderator

Re: detecting tablespace fragmentation [message #127610 is a reply to message #127591]

Tue, 12 July 2005 08:59

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Hi Tarun

For info sake, may we all know the way, how u resolved this.

Regds
Girish

Report message to a moderator

Re: detecting tablespace fragmentation [message #127717 is a reply to message #127610]

Wed, 13 July 2005 00:47

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Hi Girish,

I used the command ,

SQL> ALTER TABLESPACE tablespace_name COALESCE;

& it worked.

Thanks for ur concern .

Tarun

Report message to a moderator

Re: detecting tablespace fragmentation [message #127734 is a reply to message #127717]

Wed, 13 July 2005 01:23

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Thnx Tarun

Report message to a moderator

Previous Topic:	pls help
Next Topic:	db export from linux to solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 11:18:27 CST 2025