RE: PLSQL CPU consumption

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

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