Re: redo copy latch low??
Take a look at this article from Steve Adams: http://www.ixora.com.au/tips/tuning/redo_latches.htm Jared On Monday 28 May 2001 10:25, Raghu Kota wrote: Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle stats. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: redo copy latch low??
Just pulled up this info from Oracle Docs Well, If you could give some inputs as to the performance issues that u r facing bacause of this - it would be useful. Also, what type of application are u running? Here is the info: * Reducing Contention for Redo Copy Latches On multiple-CPU computers, multiple redo copy latches allow multiple processes to copy entries to the redo log buffer concurrently. The default value of LOG_SIMULTANEOUS_COPIES is the number of CPUs available to your Oracle instance. If you observe contention for redo copy latches, add more latches by increasing the value of LOG_SIMULTANEOUS_COPIES. It can help to have up to twice as many redo copy latches as CPUs available to your Oracle instance. ** Rajaram. -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Subject:redo copy latch low?? Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle stats. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: redo copy latch low??
Thanks jared!! and who responded. From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED], Raghu Kota [EMAIL PROTECTED] Subject: Re: redo copy latch low?? Date: Mon, 28 May 2001 10:22:41 -0700 Take a look at this article from Steve Adams: http://www.ixora.com.au/tips/tuning/redo_latches.htm Jared On Monday 28 May 2001 10:25, Raghu Kota wrote: Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle stats. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: redo copy latch low??
Can I know how can I get the ratio redo copy latch from TOAD ? -Original Message- Sent: Tuesday, May 29, 2001 2:20 AM To: Multiple recipients of list ORACLE-L Take a look at this article from Steve Adams: http://www.ixora.com.au/tips/tuning/redo_latches.htm Jared On Monday 28 May 2001 10:25, Raghu Kota wrote: Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle stats. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
