Home » RDBMS Server » Performance Tuning » migrating SYS from DICT to LOCAL
migrating SYS from DICT to LOCAL [message #166674] Fri, 07 April 2006 08:26 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
i would like to know the implications if users faced when they have tried to make SYSTEM tablespace as 'LOCAL' as against 'DICTIONARY'.


We plan to do the same but are unaware of the advantages/disadvantages if any ??

Re: migrating SYS from DICT to LOCAL [message #166680 is a reply to message #166674] Fri, 07 April 2006 08:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
None.
But you need to migrate other 'regular' tablespaces also to LMT.
If the SYSTEM is LMT, no other tablespace can be DMT.
Re: migrating SYS from DICT to LOCAL [message #166742 is a reply to message #166674] Sat, 08 April 2006 01:07 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
ny idea if i can get statistics (any scripts/queries) that report the performance or any other gains after moving from DMT to LMT ??
Re: migrating SYS from DICT to LOCAL [message #166766 is a reply to message #166742] Sat, 08 April 2006 04:18 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Read about it.You will understand. Because , you have no other choice. LMT was introduced in 8i almost (almost 7 years ago). In present times, there is no reason for any oracle database to use DMT. Either you live worrying about space management or switch to LMT with uniform extent size and spend your time in a better way.
Anyhow DMT will be de-supported soon.

[Updated on: Sat, 08 April 2006 04:18]

Report message to a moderator

Previous Topic: Performance Tuning Tool
Next Topic: Database speed up
Goto Forum:
  


Current Time: Fri Mar 29 02:52:15 CDT 2024