Hi Pando.

As I understand it -

V$OPEN_CURSOR only has cursors that have not been closed by the sessions.

V$SQL, V$SQLTEXT, etc has all SQL statements that are in the cache. (they might not be open any more)

So if somethign is in V$OPEN_CURSOR, you should be able to find it in V$SQL, but not always the other way around...

In V$OPEN_CURSOR, the rows disappear when the session disappears. Not true with V$SQL.

Also, if the same query has been executed by many sessions, it will have a row for each session in V$OPEN_CURSOR. In V$SQL, etc, it will have only one row.

-John

[Edited by jdorlon on 06-04-2001 at 04:36 PM]