Oracle-L: RE: Anyone use V$SESSION

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Thu, 07 Mar 2002 13:03:41 -0800
Message-ID: <F001.004228F5.20020307130341@fatcity.com>

Steve,

I suspect this could be another BUG like your old V$sysstat.

By any chance you have set the _sql_exec_progression_cost to lowest values?

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

-----Original Message-----
Sent: Thursday, March 07, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L

Is my V$SESSION_LONGOPS view broken?

Check out the curious results below. Notice the changing SID-serial# and how elapsed seconds gyrates. None of the below sessions are in V$SESSION. The sql address and hash is not extant in V$SQL, V$SQLAREA, etc. (Note, we are using PQO with timed statistics.)
also send the HELP command for other information (like subscribing).

Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: K Gopalakrishnan
INET: kaygopal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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). Received on Thu Mar 07 2002 - 15:03:41 CST

RE: Anyone use V$SESSION_LONGOPS ???