open cursors

[Sweetie]

Hi

I am querying v$open_cursor and it always shows myand other users last SQL statement, does this mean that my last SQL cursor is not closed?

[r_sonakiya]

When you execute your statement it opens a cursor(Implicit Cursor) for you.Once it returns you the result then only that Cursor is closed. Your query showing your statement with OPEN CURSOR AS IT'S WAITING THE RESPONSE FROM THE DATABASE.

[Sweetie]

I did

select * from emp;

then I got the results back, now it suppose that if if I query v$open_cursor I must not see anything right? But I am seeing

select * from emp

in v$open_cursor

it´s not closed?

[Sweetie]

hi can anyone help me with this

[sreddy]

Iam not sure. But, Definition of View says:

V$OPEN_CURSOR lists cursors that each user session currently has opened and parsed.

From my understanding, its showing up cuz, its parsed and its available in shared SQL area. Thats why. Doensn' mean its not closed.

[LND]

try to use V$SESSION_CURSOR_CACHE
it has field OPEN: NUMBER --Current number of open cursors

[pando]

hm I dunno neither

but when I query open from V$SESSION_CURSOR_CACHE

I get 0? But there are at leats 8 cursors opened :D

[LND]

"but when I query open from V$SESSION_CURSOR_CACHE I get 0? But there are at leats 8 cursors opened "
in the same session?

[pando]

no in 10 sessions, so that column only displays current session?

[LND]

"no in 10 sessions, so that column only displays current session?"
from definition (sorry, loose description) it seems so.