Home » RDBMS Server » Server Administration » difference between the dictionary and locally managed tablespaces in recovery process
difference between the dictionary and locally managed tablespaces in recovery process [message #62033] Mon, 21 June 2004 03:36 Go to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
hi

i know the main difference between dictionary and locally managed tablespaces but i want to know in event of failure and when we perform recovery process, from performance or from any point of view do have any differnce between this two tablespaces...

advance Thanks

D.Dilip

Report message to a moderator

Re: difference between the dictionary and locally managed tablespaces in recovery process [message #62070 is a reply to message #62033] Wed, 23 June 2004 06:34 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Parallel recovery can be faster for locally managed tablespaces, as it reduces possible ST enqueue contention. However, I don't think it will generally make much of a difference.

Best regards.

Frank

Report message to a moderator

Previous Topic: Tablespaces, Oracle
Next Topic: dbms_job with two database links
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:17:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.