Question on Cursors

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 29 Nov 1999 18:02:25 GMT
Message-ID: <3842bf62.12465562@news.earthlink.net>

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?

Thanx

---

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

Received on Mon Nov 29 1999 - 12:02:25 CST