OraFAQ Forum: Performance Tuning » migrating SYS from DICT to LOCAL

Home » RDBMS Server » Performance Tuning » migrating SYS from DICT to LOCAL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

migrating SYS from DICT to LOCAL [message #166674]

Fri, 07 April 2006 08:26

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 ??

Report message to a moderator

Re: migrating SYS from DICT to LOCAL [message #166680 is a reply to message #166674]

Fri, 07 April 2006 08:50

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: migrating SYS from DICT to LOCAL [message #166742 is a reply to message #166674]

Sat, 08 April 2006 01:07

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 ??

Report message to a moderator

Re: migrating SYS from DICT to LOCAL [message #166766 is a reply to message #166742]

Sat, 08 April 2006 04:18

Mahesh Rajendran
Messages: 10708
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 22:57:40 CDT 2025