SQL parsing would also be reflected in rowcache because, to parse
successfully, you
need dictionary and parse locks.
--
Mladen Gogala
Oracle DBA
> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of Sam Roberts
> Sent: Friday, September 26, 2003 2:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ROW CACHE HIGH - Priority 1
>
>
> sql parsing would be reflected in Library cache not rowcache
>
> Basic stuff
>
> Sam
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, September 24, 2003 1:14 PM
>
>
> > General answer: upgrade to 9.2.0.4 and hope that the bug has been
> > fixed. Row cache locks are data dictionary locks. You can see the
> > contents of row cache by inspecting v$rowcache. You may need to
> > increase shared pool. Last but not least, how fast is your private
> > network connection between
> the
> > two nodes? 100mbit/sec is not nearly fast enough. You need
> at least a
> > gigabit switch. Also check your SQL for hard parsing (see the
> > executions and invalidations in
> > v$sqlarea), ad-hoc DDL and that kind of stuff.
> > And no, it's not my priority 1.
> >
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> >
> >
> >
> > > -----Original Message-----
> > > From: ml-errors_at_fatcity.com
> [mailto:ml-errors_at_fatcity.com] On Behalf
> > > Of Muqthar Ahmed
> > > Sent: Wednesday, September 24, 2003 3:50 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: ROW CACHE HIGH - Priority 1
> > >
> > >
> > > Hi,
> > >
> > > I have Oracle 9.2.0.2.0 RAC (two nodes) on IBM AIX.
> Currently I am
> > > seeing very high number for ROW CACHE LOCK in statspack.
> > >
> > > Top 5 Timed Events
> > > ~~~~~~~~~~~~~~~~~~
> > > % Total
> > > Event Waits
> > > Time (s) Ela Time
> > > -------------------------------------------- ------------
> > > ----------- --------
> > > row cache lock 11,310 5,441
> > > 86.97
> > > CPU time
> > > 522 8.34
> > > global cache cr request 32,513 71
> > > 1.14
> > > global cache null to x 21,507 57
> > > 91
> > > log file sync 22,689 49
> > > .78
> > >
> > > -------------------------------------------------------------
> > >
> > > Get
> > > Spin &
> > > Latch Name Requests Misses
> > > Sleeps Sleeps 1->4
> > > -------------------------- --------------
> > > ----------- ----------- ------------
> > > library cache 7,094,208 31,499
> > > 1,480 30031/1456/12/0/0
> > > shared pool 2,385,408 6,739
> > > 527 6212/527/0/0/0
> > > ges enqueue table freelist 1,492,275 1,903
> > > 124 1780/122/1/0 /0
> > > library cache pin 3,201,008 1,437
> > > 130 1307/130/0/0/0
> > > row cache objects 1,400,498 1,020
> > > 56 964/56/0/0/0
> > > row cache enqueue latch 1,292,843 715
> > > 19 696/19/0/0/0
> > >
> > > It is holding row cache lock (v$session_wait), other
> sessions are in
> > > the queue....due to this, number of concurrent sessions will
> > > increase from 100 to 350 sessions on each node. In less than one
> > > minute everything will be cleared ( OLTP database)
> > >
> > > I have already opened a TAR with Priority 1. Do you have any
> > > suggestions.
> > >
> > > Thanks
> > > Muqthar Ahmed
> > > DBA
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Muqthar Ahmed
> > > INET: Muqthar.Ahmed_at_decoratetoday.com
> > >
> > > 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).
> > >
> >
> >
> >
> >
> > Note:
> > This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information.
> No confidentiality or privilege is waived or lost by any
> mistransmission. If you receive this message in error,
> please immediately delete it and all copies of it from your
> system, destroy any hard copies of it and notify the sender.
> You must not, directly or indirectly, use, disclose,
> distribute, print, or copy any part of this message if you
> are not the intended recipient. Wang Trading LLC and any of
> its subsidiaries each reserve the right to monitor all e-mail
> communications through its networks.
> > Any views expressed in this message are those of the individual
> > sender,
> except where the message states otherwise and the sender is
> authorized to state them to be the views of any such entity.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> > INET: mladen_at_wangtrading.com
> >
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sam Roberts
> INET: rabbit_at_emirates.net.ae
>
> 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).
>
Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mladen_at_wangtrading.com
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).
Received on Fri Sep 26 2003 - 08:54:55 CDT
