Re: PLSQL CPU consumption

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

Adrian,

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.

cheers
anand

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.



Cheers

Adrian


 ------------------------------

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


http://asktom.oracle.com/pls/ask/f?p=4950:8:15838649304879256784::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:904605517791

Thanks
Riyaj





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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006