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
 
Regards
Naveen
-----Original Message-----
From: RAJESH DAYAL [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Redo Logs Problem

Just Out of curiosity….

 

How come changing the TS to LMT would reduce the excessive Redo generation.

 

Regards,

Rajesh

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of VIVEK_SHARMA
Sent: Monday, August 04, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Redo Logs Problem

 

Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation

 

 

-----Original Message-----
From: Munish Bajaj [mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Redo Logs Problem

 

Hi Listers,

 

One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client).

 

Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated.

 

Regards

 

Munish Bajaj

 


Upgrade Your Email - Click here!

DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.

Reply via email to