Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Open cursors and more open cursors
v$sql.open_versions > 0 ? I think this would be the real total also you can
use v$sql.parsing_user_id or parsing_schema_id for userwise grouping.
Scott Watson <scott.watson_at_home.com> wrote in message
news:KwNV3.9225$Q5.376178_at_news1.rdc1.ab.home.com...
> When I select select sid, count(*) from v$open_cursor group by sid; I
find
> some sessions have 250 open cursors. I am 99% confident that there are
not
> 250 cursors open but why is this view reporting so many. (in fact some
are
> duplicates same address and hash value 2,3,4,5 times)
>
> I believe the developers are using implicit cursors in some situations but
> shouldn't they be closed after the procedure ends. If not is there anyway
> to close the implicit cursor explicitly? Lastly how can I tell how much
> memory is being wasted by having all these opened cursors.
>
>
> Thanks,
> scott.
>
>
Received on Tue Nov 09 1999 - 06:24:53 CST