Re: Online Cursors

From: Yong Huang <yong321_at_yahoo.com>
Date: 26 Dec 2003 10:47:45 -0800
Message-ID: <b3cb12d6.0312261047.79d0e112@posting.google.com>

"Ahmed Baraka" <baraka_ahmed_at_hotmail.com> wrote in message news:<bsfdhq$dpr4_at_news.emirates.net.ae>...
> Hi there,
> How can I dispaly number of cursors currently running in Oracle 9.

Hi, Ahmed,

The SQLs (cursors) that are being executed are shown in v$sql(area) where users_executing > 0. I wouldn't use v$open_cursor, which may contain cursors not being executed at the moment.

Yong Huang Received on Fri Dec 26 2003 - 12:47:45 CST