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@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




Other related posts: