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.




Reply With Quote