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: 68716
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: 68716
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: 68716
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: Thu Nov 21 17:03:44 CST 2024