Home » RDBMS Server » Server Administration » Fragmentation in database (oracle,10201,hpux 11.1)
Fragmentation in database [message #299396] Mon, 11 February 2008 17:16 Go to next message
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
Re: Fragmentation in database [message #299408 is a reply to message #299396] Mon, 11 February 2008 22:48 Go to previous messageGo to next message
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.
Re: Fragmentation in database [message #299414 is a reply to message #299396] Mon, 11 February 2008 23:27 Go to previous message
Michel Cadot
Messages: 64152
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
Previous Topic: how to delete index stats
Next Topic: How to increase user session to Database
Goto Forum:
  


Current Time: Sat Dec 10 08:52:05 CST 2016

Total time taken to generate the page: 0.10594 seconds