| 
		
			| Row Cache Problem - 9i RAC [message #267735] | Fri, 14 September 2007 08:28  |  
			| 
				
				
					| orasaket Messages: 70
 Registered: November 2006
 | Member |  |  |  
	| Hi, 
 We are using Oracle 9i(RAC) on linux
 
 I am constantly observing 'row cache lock' and 'KJC: Wait for msg sends to complete	null'in v$session_wait.
 
 The session observed is stalling and consuming 95% CPU all the time
 
 I have mentioed the records in v$session_wait, V$lock and V$rowcache.
 
 Can anybody help me identifiing the problem
 
 Thanks and Regards,
 OraSaket
 
 
 
 |  
	|  |  | 
	| 
		
			| Re: Row Cache Problem - 9i RAC [message #267736 is a reply to message #267735] | Fri, 14 September 2007 08:33   |  
			| 
				
				
					| orasaket Messages: 70
 Registered: November 2006
 | Member |  |  |  
	| Hi, 
 The query stalling and assoicated plan is as mentioned below
 
 
 
select   lcpedseq, dtbeneff, dtbenexp, dtclaimfrmyr, dtclaimtoyr, nstatus
FROM     cl
WHERE    strpolnbr = :b
AND      (   dtbeneff <= :b1
          OR :b1 IS NULL 
		  )
AND      nstatus <> 2
ORDER BY dtbeneff DESC,
         dtbenexp DESC,
         dtcreated DESC
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=14 Card=3 Bytes=174)
   1    0   SORT (ORDER BY) (Cost=14 Card=3 Bytes=174)
   2    1     TABLE ACCESS (BY INDEX ROWID) OF C
          L' (Cost=13 Card=3 Bytes=174)
   3    2       INDEX (RANGE SCAN) OF 'INDX_POLNBR_CPED_IDX' (NON-UNIQ
          UE) (Cost=4 Card=36)
 Regards,
 OraSaket
 |  
	|  |  | 
	|  | 
	|  | 
	|  | 
	|  | 
	| 
		
			| Re: Row Cache Problem - 9i RAC [message #267937 is a reply to message #267936] | Sun, 16 September 2007 14:25   |  
			| 
				
				
					| kumarsz Messages: 180
 Registered: March 2005
 Location: canada
 | Senior Member |  |  |  
	| Michel, 
 We are using 9.2.0.6 only
 
 Meanwhile can it be Bug 4313246?
 
 Michel, it's really great to get your help on weekends too.
 
 Thanks and Regards,
 Pratap
 |  
	|  |  | 
	|  |