Re: Closing Cursors

A copy of this was sent to news_at_abc.co.uk (Peter L) (if that email address didn't require changing) On Fri, 11 Feb 2000 18:31:14 GMT, you wrote:

>I seem to remember reading in this newsgroup about a parameter that
>had to set to make sure that Oracle really closed cursors when you
>told it to. The default action was to leave them open in case you
>needed them again.
>
>Can anyoen supply details of this or have I dreamt it?

close_cached_open_cursors

unsupported in 8i and up (but hopefully should not be needed then)..

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Feb 11 2000 - 15:24:37 CST