OraFAQ Forum: Server Administration » Bubble Fragmentation

Home » RDBMS Server » Server Administration » Bubble Fragmentation

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

Bubble Fragmentation [message #288056]

Fri, 14 December 2007 09:33

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

Report message to a moderator

Re: Bubble Fragmentation [message #288057 is a reply to message #288056]

Fri, 14 December 2007 09:38

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

Report message to a moderator

Re: Bubble Fragmentation [message #288076 is a reply to message #288056]

Fri, 14 December 2007 12:43

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.

Report message to a moderator

Re: Bubble Fragmentation [message #288078 is a reply to message #288056]

Fri, 14 December 2007 13:02

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.

Report message to a moderator

Re: Bubble Fragmentation [message #288079 is a reply to message #288076]

Fri, 14 December 2007 13:03

Michel Cadot
Messages: 68686
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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:20:43 CDT 2024