Home » Server Options » RAC & Failsafe » Row Cache Problem - 9i RAC
- Row Cache Problem - 9i RAC [message #267735] Fri, 14 September 2007 08:28 Go to next message
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 Go to previous messageGo to next message
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 #267933 is a reply to message #267735] Sun, 16 September 2007 13:31 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,

Somebody please help on this.

Thanks and Regards,
Pratap
- Re: Row Cache Problem - 9i RAC [message #267934 is a reply to message #267933] Sun, 16 September 2007 13:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is week-end, be patient until Monday.
If you are in hurry you can call Oracle support.

Regards
Michel
- Re: Row Cache Problem - 9i RAC [message #267935 is a reply to message #267934] Sun, 16 September 2007 13:39 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Oh Sorry Michel !! Sad

Any ways have good time

Thanks and Regards,
Pratap
- Re: Row Cache Problem - 9i RAC [message #267936 is a reply to message #267935] Sun, 16 September 2007 14:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This may be bug 3561040 fixed in 9.2.0.6 or Bug 4672266 fiwed in 9.2.0.8

Regards
Michel

- Re: Row Cache Problem - 9i RAC [message #267937 is a reply to message #267936] Sun, 16 September 2007 14:25 Go to previous messageGo to next message
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
- Re: Row Cache Problem - 9i RAC [message #267939 is a reply to message #267937] Sun, 16 September 2007 14:56 Go to previous message
Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It may be.

Regards
Michel
Previous Topic: RAC install - - - ASM and OCR file error
Next Topic: Can PHP leverage RAC?
Goto Forum:
  


Current Time: Sun May 04 21:42:09 CDT 2025