Re: Can I get more information on open cursors?

> Looking for some information on open cursors. Is it possible to get a
> detailed description on the sql statement that is resulting in an open
> cursor being left behind. This would be really helpful in tracking
> down the missing one.
>
> Right now, we are losing a cursor in our program (about 1 every 250
> records), but cannot locate the 'offender'. If it is possible to get a
> listing of the SQL statement that causes this problem it would be much
> easier to track down.
>
> Any help would be greatly appreciated.
>
> Thanks
> Prem

Try

select * from v$open_cursor Received on Fri Nov 09 2001 - 09:00:41 CET