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
|
|
|
|