Re: PLSQL CPU consumption

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_at_gmail.com> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Riyaj Shamsudeen
> *Sent:* 26 September 2006 16:20
> *To:* Bernard.Polarski_at_atosorigin.com
> *Cc:* oracle-l_at_freelists.org
> *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

--
http://www.freelists.org/webpage/oracle-l