Sekedar sharing, ini saya dapat dari asktom. Semoga dapat membantu :) Hi Tom
My db version is Oracle 9iR2,but tablespaces are dictionary managed. Is there any performance gain, if I migrate the tablespaces from dictionary managed to locally managed? Followup April 14, 2009 - 11am Central time zone: The main things locally managed offer are a) faster extent allocation - both in serial and highly concurrent environments. They scale better if you are adding lots of extents frequently. In general, this shouldn't be the case (if it is, alter your next extents so they grow a tad slower). So, while this is nice - it might not matter. b) fast extent de-allocation. This only affects you if you truncate and release storage or drop things with lots of extents frequently. And quite frankly - if you do, you just need to adjust your initial/next extent sizes so the things you drop/truncate frequently have less extents. So, again, nice - but it might not matter. c) vastly improved storage allocation with system allocated extents. No more initial, next, pctincrease, minextents, maxextents. You just let us figure out how many extents of what size to use. Nothing could be easier. But you already have everything in place.... so..... I would not MIGRATE a tablespace to locally managed - that is sort of a hack. If you want to start utilizing locally managed tablespaces - you would create a new empty one (with system allocated extent sizes!) and either 1) alter move/rebuild segments into it. 2) dbms_redefinition them into it. That is: you would 'reorganize' into it. http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5407667486703 url: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5407667486703 Best Regards, Taufiq [Non-text portions of this message have been removed]
