Re: kqreqd: reget
From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 3 Sep 2011 11:57:35 -0700 (PDT)
Message-ID: <1315076255.95213.YahooMailClassic_at_web80603.mail.mud.yahoo.com>
> Does anyone know what Oracle wants to do when there is too much activity
> on this location of the row cache objects?
>
> I haven't found the meaning, either on google or metalink.
Date: Sat, 3 Sep 2011 11:57:35 -0700 (PDT)
Message-ID: <1315076255.95213.YahooMailClassic_at_web80603.mail.mud.yahoo.com>
> Does anyone know what Oracle wants to do when there is too much activity
> on this location of the row cache objects?
>
> I haven't found the meaning, either on google or metalink.
Bug 10057951 says kqreqd is "enqueue delete". You can actually find quite a number of bugs if you do advanced search on MOS. To narrow down, check your v$rowcache to see which type of row cache has the highest gets or its gets is increasing the fastest, and compare with each bug you find. Also compare call stack if you have a trace file.
The kqreqd function seems to be related to internal error 4886 (ora-00600 [4886]), and event 10222 ("row cache"), if you want to search more.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Sep 03 2011 - 13:57:35 CDT