Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Locally Managed vs Dictionary managed tablespaces
Another advantage of dictionary managed tablespaces is that they are
more flexible than locally managed tablespaces. That's why I don't
think they are going away any time soon.
The dbms_space_admin package offers two procedures, tablespace_migrate_to_local and tablespace_migrate_from_local, to move from one to the other and so switching is a possibility without having to completely recreate the tablespace. The time it takes to do the switch, however, may not be insignificant.
Frank Hubeny
Leigh wrote:
>Does anyone agree/disagree with Steve's synopsis of locally managed
>tablespaces particularly that they can cause much more physical IO
>than dict managed for tablespaces with many small segments? Has
>anyone had any significant improvment after using them on moderately
>sized databases - eg. 10 - 20GB or any phobia of using them?
>
Received on Fri Nov 02 2001 - 00:33:31 CST