Oracle-L: ROW CACHE HIGH

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Wed, 24 Sep 2003 11:49:54 -0800
Message-ID: <F001.005D0F31.20030924114954@fatcity.com>

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). Received on Wed Sep 24 2003 - 14:49:54 CDT

ROW CACHE HIGH - Priority 1