| mit |
Posted: Feb 26, 2007 09:22:29 AM |
Total Post: 40
Joined: Sep, 2006
|
what is diff. between dictionary manage and locally manage
thanx |
|
|
 Jayanta |
| Posted: Feb 26, 2007 12:36:19 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
a dictionary managed tablesoace is one whose free space management is done in data dictionary that resides in system tablespace.
where as a locally managed tablespace means the free space for the tablespace is managed with in the tablespace using bitmaps.
locally managed tablespaces gives better performance in comparison to dmt.
but if ur system tablespace is locally managed then other tablespaces r also locally managed.
and in near future oracle may stop supporting dictionary managed tablespaces.
regards
jayanta
|
|
|
|
|
| dba |
| Posted: Apr 09, 2007 12:54:01 PM | |
|
Total Post: 6
Joined: Apr, 2007
|
Hi Jayanth,
Is it true that locally managed tablespace has not fragmentation issue.
When we had dictionary managed tablespace, there was always a need to reorg.
thanks in advance
|
|
|
|
|
| Jayanta |
| Posted: Apr 18, 2007 01:27:49 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
yes it is free from fragmentation issues.
cheers!
|
|
|
|
|
| dba |
| Posted: Apr 18, 2007 02:42:04 PM | |
|
Total Post: 6
Joined: Apr, 2007
|
Hi Jayanth,
thanks for clearing the doubt. Is there a query to identify if the tablespace is dict managed or local. I have the script to change it. But donot have a query to check.
I could use tools to check which i don't want. Please let me know if there is a script available. thanks
|
|
|
|
|
| Murtuja |
| Posted: Feb 14, 2008 11:35:07 PM | |
|
Total Post: 816
Joined: Jan, 2006
|
query to identify if the tablespace is dict managed or local
SELECT tablespace_name, extent_management, segment_space_management
FROM dba_tablespaces
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
