Re: How to obtain number of opened cursors from any opened session

In article <3b41da32$1_at_news.vogel.pl>, "Olek" says...
>
>I would like to get the number of curently opened cursors by any active
>session.
>Is any dynamic V$ view from where I can obtain this info, or mayby any other
>way ?
>I know V$SESSION_CURSOR_CACHE but it applays only to session opened by me.
>
>Thanks in advance
>Alex
>
>
>
>

ops$tkyte_at_ORA817.US.ORACLE.COM> select a.name, b.sid, b.value   2 from v$sesstat b, v$statname a where a.name like 'opened cursor%'   3 and a.statistic# = b.statistic#
/ 4

NAME                                  SID      VALUE
------------------------------ ---------- ----------
opened cursors cumulative               1          1
opened cursors cumulative              24         77
opened cursors cumulative              21         77
opened cursors cumulative              20          0
opened cursors cumulative              19          0
opened cursors cumulative              18          0
opened cursors cumulative              17          0
opened cursors cumulative              15        102
opened cursors cumulative              14         77
opened cursors cumulative              11         16
opened cursors cumulative               9          0
opened cursors cumulative               8         17
opened cursors cumulative               7         16
opened cursors cumulative               6        242
opened cursors cumulative               5       1840
opened cursors cumulative               2          0
opened cursors cumulative               4          0
opened cursors cumulative               3          0
opened cursors current                  1          0
opened cursors current                 24          4
opened cursors current                 21          4
opened cursors current                 20          0
opened cursors current                 19          0
opened cursors current                 18          0
opened cursors current                 17          0
opened cursors current                 15          1
opened cursors current                 14          4
opened cursors current                 11          1
opened cursors current                  9          0
opened cursors current                  2          0
opened cursors current                  4          0
opened cursors current                  6          0
opened cursors current                  8          1
opened cursors current                  7          1
opened cursors current                  5          0
opened cursors current                  3          0

36 rows selected.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp