Re: PLSQL CPU consumption

  • From: "Anand Rao" <panandrao@xxxxxxxxx>
  • To: ade.turner@xxxxxxxxx
  • Date: Wed, 27 Sep 2006 11:14:04 +0530


i found some bugs on Metalink for 10.2 and ref cursors and stored
procedures. a problem affecting JDBC as well as OCI.

could be affecting 9206 also. i think you could raise an SR and get it
sorted out, could be a bug.


On 27/09/06, Adrian <ade.turner@xxxxxxxxx> wrote:

Thanks Riyaj,

I was not aware of this and of course it explains the symptoms, and why
session_cached_cursors has worked.

Very appreciated.




*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Riyaj Shamsudeen
*Sent:* 26 September 2006 16:20
*To:* Bernard.Polarski@xxxxxxxxxxxxxx
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: PLSQL CPU consumption

Of course, since you use ref cursor, they MUST be soft parsed. Read Tom Kyte's website.,F4950_P8_CRITERIA:904605517791


All I need to make a comedy is a park, a policeman and a pretty girl -
Charlie Chaplin

Other related posts: