Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How many cursors can

How many cursors can

From: HB942 <hb942_at_aol.com>
Date: 7 Dec 1998 23:12:43 GMT
Message-ID: <19981207181243.09622.00001210@ng-fu1.aol.com>


I want to determine how many cursors each user session has open. I entered

    select s.sid, value "# open cursors" from v$sesstat s, v$statname n       where s.statistic#=n.statistic# and n.name='opened cursors current'; One sid had a value of well over 2000! Max_cursors is set well below that. Is this the right statistic to determine how many cursors a user has open? TIA
Cory Brooks Received on Mon Dec 07 1998 - 17:12:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US