Re: Question on Cursors

A copy of this was sent to andreyNSPAM_at_bookexchange.net (NetComrade) (if that email address didn't require changing) On Mon, 29 Nov 1999 18:02:25 GMT, you wrote:

>SVRMGR> show parameter cursor
>NAME TYPE VALUE
>----------------------------------- -------
>------------------------------
>close_cached_open_cursors boolean FALSE
>
>cursor_space_for_time boolean FALSE
>
>open_cursors integer 50
>
>row_cache_cursors integer 10
>
>session_cached_cursors integer 0
>
>
>SQLWKS> select user_name, count(*) from v$open_cursor group by
>user_name
> 2>
>USER_NAME COUNT(*)
>------------------------------ ----------
>WWW 565
>SYSTEM 1
>2 rows selected.
>
>How is that possible?
>

WWW is logged in more then once.

try

select user_name, SID, count(*) from v$open_cursor group by user_name, SID;

to get counts by username/session.

>Thanx
>
>---------------
>Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>AOL: NetComrade ICQ: 11340726 remove NSPAM to email

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Nov 29 1999 - 12:59:27 CST