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
Messages: 60
Registered: November 2007
Location: DALLAS
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)?

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
Messages: 754
Registered: October 2007
Senior Member
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: 65082
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).

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

Current Time: Fri Jul 21 01:50:56 CDT 2017

Total time taken to generate the page: 0.16987 seconds