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: [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).
