Re: Open cursors
From: Andrew Velichko <andrew_velichko_at_yahoo.com>
Date: Thu, 28 Dec 2000 15:42:58 -0500
Message-ID: <qCN26.103219$Z2.1261728_at_nnrp1.uunet.ca>
Date: Thu, 28 Dec 2000 15:42:58 -0500
Message-ID: <qCN26.103219$Z2.1261728_at_nnrp1.uunet.ca>
Hi Jürgen!
The following statement will display information on cursor usage for the
current session:
select * from v$session_cursor_cache;
The next statement will show you current value: select * from v$parameter where name='open_cursors';
open_cursors is static parameter and can be changed only in parameter file.
Andrew Velichko
Brainbench MVP for Oracle Developer 2000
http://www.brainbench.com
"Jürgen Wagner" <wagner_at_danet.de> wrote in message
news:1103_978032809_at_telemann...
> Hello all,
> is there a way to determine how many open cursors there are currently
and what the allowed maximum is?
>
> Your help is greatly appreciated.
>
> Cheers,
> --Jürgen Wagner
>
>
>
Received on Thu Dec 28 2000 - 21:42:58 CET