Home » RDBMS Server » Server Administration » Bubble Fragmentation
Bubble Fragmentation [message #288056] Fri, 14 December 2007 09:33 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
How can one remove/eliminate bubble fragmentation within the tablespace? The TBS is locally managed. but the prvs DBA had set the auto extend on to 8k at a time.

Thank you
K V
Re: Bubble Fragmentation [message #288057 is a reply to message #288056] Fri, 14 December 2007 09:38 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>How can one remove/eliminate bubble fragmentation within the tablespace?
Move all the resident object out of this tablespace to eliminate "fragmentation".
But WHY do you care about "fragmenation"?
You should have other more pressing, meaningful, & relevant issues to deal with; rather than wasting your time worrying unnecessarily about fragmenation.
Re: Bubble Fragmentation [message #288076 is a reply to message #288056] Fri, 14 December 2007 12:43 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
I totally agree with you. But the so called "HIGHER MANAGEMENT" is somehow worried because I said there is some amount of fragmentation in the database and these guys are stuck to it saying, how can we reduce that now?

I would appreciate any inputs in this front!

Thank you.
Re: Bubble Fragmentation [message #288078 is a reply to message #288056] Fri, 14 December 2007 13:02 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
YOu need not to worry about fragmentation with LMT.
you can manually defragment it with alter tablespace coalesce...
but as Ana rightly said,,
Quote:

You should have other more pressing, meaningful, & relevant issues to deal with; rather than wasting your time worrying unnecessarily about fragmenation.
Re: Bubble Fragmentation [message #288079 is a reply to message #288076] Fri, 14 December 2007 13:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Tell them you have to export, drop the objects, reimport them, regrant all privileges, and this will take time and nobody can work during it and it is risky.

Regards
Michel

[Updated on: Fri, 14 December 2007 13:03]

Report message to a moderator

Re: Bubble Fragmentation [message #288193 is a reply to message #288079] Sat, 15 December 2007 12:14 Go to previous message
kudur_kv
Messages: 75
Registered: February 2005
Member
Thank you very much!!

Appreciate all your inputs. I will put that across very diplomatically!

Thank you again comrades!!!

KV
Previous Topic: error when running statspak
Next Topic: Can't create index as user
Goto Forum:
  


Current Time: Fri Dec 02 14:21:47 CST 2016

Total time taken to generate the page: 0.05495 seconds