Whoops, of course I meant the exact opposite; it has a default value of
false
and setting it to true would make it behave as you expect.
--
Scott Thompson
The Dyslexic DBA Consultant
Scott Thompson wrote:
> Oracle caches, keeps open, cursors even after a commit or rollback.
> This
> is controlled
> by the server parameter 'close_cached_open_cursors', which has a
> default
> value of true.
> A setting of false will force the behavior your expecting.
>
> --
> Scott Thompson
> DBA Consultant
Received on Fri Aug 01 1997 - 00:00:00 CDT
