RE: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

select /*+ ordered */

   s.username
,st.address
,st.sql_text

from

   v$session s
,v$open_cursor oc
,v$sqltext st

where

   s.sid = &&usid
   and s.saddr = oc.saddr
   and st.address = oc.address and st.hash_value = oc.hash_value order by st.address, st.piece
/

"Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
Sent by: ml-errors_at_fatcity.com
 08/07/2003 02:19 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

Yes, V$OPEN_CURSOR is instance-wide, but each row in the view sure looks like it can be attributed to a specific session via SADDR/ID/USERNAME. And the count of those rows for each session doesn't match the corresponding row/attribute in V$SESSSTAT.

Erm, I'll leave off the product name here since this is the only DB problem
I've seen with it, but I will say that it's a bug tracking package.

Thanks,
Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).