| fragmentation in LMT ? [message #184273] |
Wed, 26 July 2006 00:18  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
1) how is fragmentation controled in LMT ??
2) also are blocks used if they are free, but not in a continous representation.
ie. say block size 4k, but table update of 8k
free blocks due to deletes are 2 but they are not continous.
UUUUFUUFUU
U=Used
F=Free (due to deletes)
so will these 2 blocks be used ??
|
|
|
|
| Re: fragmentation in LMT ? [message #184334 is a reply to message #184273] |
Wed, 26 July 2006 03:48  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
LMT & Fragmentation
http://orafaq.com/node/3
http://asktom.oracle.com/pls/ask/f?p=4950:8:4714105700810096133::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1163235055159
Blocks:
When blocks a 'emptied' down to a certain level, they are made available for inserts. Updates are different. If you update a row, let's say that it is row 10 in block 1, and that update increases the size of the row, Oracle will simply perform the update, taking up more space in the current block.However, if the row grows large enough to require more space than is available in the block in which that row currently resides, Oracle will Migrate the row to another block where there is enough space, but leave a pointer in the original block to point to the row's new physical location. (This is bad as it would now require 2 I/Os to get that row)
the two blocks 'F' would be on the 'Free-list' of the segment, pointing out to Oracle that these blocks are available for inserts.
Read more from the documentation on
Extent Management, Segment Space Management, LMT's. There is a massive amount of info out there.
Jim
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
