OraFAQ Forum: Server Administration » Fragmentation in database

Home » RDBMS Server » Server Administration » Fragmentation in database (oracle,10201,hpux 11.1)

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

Fragmentation in database [message #299396]

Mon, 11 February 2008 17:16

monto
Messages: 60
Registered: November 2007
Location: DALLAS

Member

Hi Guys,
I have a confusion over fragmentation in the tables,if we have LMT then does't it eliminate any kind of fragmentation within the database or do we still have the possiblity of fragmentation within segments(table)?

Regards

Report message to a moderator

Re: Fragmentation in database [message #299408 is a reply to message #299396]

Mon, 11 February 2008 22:48

varu123
Messages: 754
Registered: October 2007

Senior Member

What
alter tablespace tablespace_name coalesce does in DMT,exactly the same thing is done by bitmaps in LMTs.
Coalesce just merge adjacent free blocks as one unit.
Hence fragmentation is reduced but not eliminated.
YOu cannot achive 100% fragmentation in any case.

Report message to a moderator

Re: Fragmentation in database [message #299414 is a reply to message #299396]

Mon, 11 February 2008 23:27

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Tablespace fragmentation is meaningless with LMT.
Table fragmentation is meaningless if you use ASSM.
The only case it is important to take care of fragmentation is when you execute bulk deletes (and don't want to reinsert data).

Regards
Michel

Report message to a moderator

Previous Topic:	how to delete index stats
Next Topic:	How to increase user session to Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 19:52:59 CDT 2024