On Sun, 3 Aug 2003, Naveen Nahata wrote: > This will reduce the updates and inserts to the Data-Dictionary tables since > in LMTs extent information is stored locally and not in Data-Dictionary
I do not believe that there are real practical examples of this making any signifgicant difference. Dictionary management doesn't account for much redo at all, even in masively misconfigured environments. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -----Original Message----- > Sent: Monday, August 04, 2003 11:59 AM > To: Multiple recipients of list ORACLE-L > > How come changing the TS to LMT would reduce the excessive Redo generation. > > -----Original Message----- > VIVEK_SHARMA > Sent: Monday, August 04, 2003 9:49 AM > > Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive > Redo generation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
