Re: cursors open in Oracle, please !!

select count(*)
from v$open_cursor;

Should be what you want.

Kenny Gump
OCP 7.3 DBA
David Novo wrote in message <789fm9$7n3$1_at_talia.mad.ttd.net>...
>Any body kows how I can see hwo many cursors are open in a database in
>Oracle 8.
>
>David
>
>
Received on Fri Jan 22 1999 - 09:52:45 CST