| Quick LMT Question [message #329020] |
Mon, 23 June 2008 13:57  |
coleing
Messages: 213
Registered: February 2008
|
Senior Member |
|
|
Hi All,
Quick question hopefully.
I have converted some tablespaces from DICTIONARY managed to LOCALLY managed.
The ALLOCATION_TYPE in DBA_TABLESPACES is now showing as USER.
Although the Oracle documentation states that this is expected, does it mean that it is now allocating space incrementally, or uniformly? (since I could usually tell this from the ALLOCATION_TYPE).
Or is it just doing the same as it was before the conversion to LMT (ie, using initial and next extent and pct_increase?).
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Quick LMT Question [message #329562 is a reply to message #329020] |
Wed, 25 June 2008 18:01  |
coleing
Messages: 213
Registered: February 2008
|
Senior Member |
|
|
I think he means that there are many benefits to LMT (like the auto allocation, re-use of space etc), however doing a conversion only gives you better performance on the issue of block header contention, as its held as a bitmap file, instead of serially updated in the dictionary. (FET$)
Thats if my understanding is correct?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Quick LMT Question [message #422669 is a reply to message #422668] |
Fri, 18 September 2009 04:11 |
QuickGun
Messages: 8
Registered: September 2009
Location: SG
|
Junior Member |
|
|
hmmm... in that case,
i would leave the system tablespaces to be DMT and the rest to LMT?
Will that benefit me? atleast NOT srew up the system?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
