Re: Redo Copy Latch contention ??

Wrong alert in HP Open view (you can configure that) and (again) ignoring other more relevant performance information ('High CPU usage'). I have never seen a system where tuning the redo copy latches made a huge improvement in performance.

Anjo.

On Wednesday 02 July 2003 22:20, you wrote:
> Thanks Kirti,
> We have HP Openview implemented on our database and hence got some alert on
> redo copy latch. When I have queried the database I found the contention on
> this latch. Yes we have other performance issues ( HIGH CPU utilization ,
> because of lotta bad code ). and We are checking every possible contention
> on the database.
>
> Question : How can I determine if this redo copy latch is causing the
> performance issues , guess that is my main question before altering some
> hidden parameter in init.ora.
>
> Madhu Reddy
> X13944
>
>
> -----Original Message-----
> Sent: Wednesday, July 02, 2003 1:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> According that suggestion you do seem to have redo copy latch contention.
> As far as getting that ratio close to suggested value, you may set some
> special init.ora parameters. There is plenty of notes on Metalink for that.
> But, you should first determine if this is causing any performance issue.
> Have you explored all other avenues to address those issues. If not, I
> would not worry about this contention.
>
> - Kirti
>
> --- "Reddy, Madhusudana" <[EMAIL PROTECTED]> wrote:
> > Hello ALL,
> >
> > Do you guys think we have redo copy latch contention ?? Also what are
> > your suggestions on tuning Redo Copy Latch ??
> >
> >
> > SUBSTR(LN.NAME,1,20) GETS
> > MISSES IMMEDIATE_GETS
> > IMMEDIATE_MISSES -------------------- ---------- ----------
> > -------------- ---------------- redo allocation
> > 943350646
> > 8862115 0 0 redo copy
> > 22097
> > 497 907958724 1592481
> >
> > 14:54:54 SQL> select (497/22097)*100 from dual;
> >
> > (497/22097)*100 ~ (misses/gets)*100
> > ---------------
> > 2.2491741 <------- Oracle suggests it
> > should be under 1%
> >
> >
> > Madhu Reddy
> > X13944
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Reddy, Madhusudana
> > 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).
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com

-- 
----------------------------------------------------------------
Anjo Kolk
http://www.oraperf.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  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).