| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tracing of the number of open cursor
> I will know the number of cursor open for sid=47, but i realise that
> this view is always remain the high value, it does not refreshing the
> current no. of open cursor in the view.
From what I understand, this view allows you to see the cursors cached in the shared pool. You can clear it by ALTER SYSTEM FLUSH SHARED_POOL.
I have noticed that cursors I know are closed still appear in this view, however, it is not the high-water mark. The numbers go down as well, as the cursors are removed from the shared pool. You can monitor the number of cursors in this view when you run your application, and see how it changes. You can also see the SQL_TEXT of the cursors and identify where your leak is.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Mar 29 2000 - 12:40:01 CST
 |
 |