Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Redo Logs Problem
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/~jwiltonReceived on Mon Aug 04 2003 - 04:05:51 CDT
> -----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: jwilton_at_speakeasy.net 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: ListGuru_at_fatcity.com (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).
![]() |
![]() |