Oracle-L: RE: Anyone use V$SESSION

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 13 Mar 2002 07:28:31 -0800
Message-ID: <F001.00427290.20020313072831@fatcity.com>

RE: Anyone use V$SESSION_LONGOPS ???John:

These are not reposts.. Infact one of my post (which I have sent long back) appeared today.

Jared: Any ideas?

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Hallas John Sent: Wednesday, March 13, 2002 6:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Anyone use V$SESSION_LONGOPS ???

There have been a few posts today which are repeat posts from a few days ago

  -----Original Message-----
  From: Mark Leith [mailto:mark_at_cool-tools.co.uk]   Sent: 13 March 2002 12:53
  To: Multiple recipients of list ORACLE-L   Subject: RE: Anyone use V$SESSION_LONGOPS ???

Is it just me, or am I having a slight case of de ja vu here ;P

  -----Original Message-----
  Lewis
  Sent: 13 March 2002 11:34
  To: Multiple recipients of list ORACLE-L

No version numbers, and no O/S details. Cary Millsap mentioned to me a little while ago that on one of his linux platforms the values you got from timed_statistics seemed to be a very good random number generator ;)

Possibly this is just a 32-bit/64-bit misalignment in code - I've seem similar silly numbers appearing for that reason.

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 07 March 2002 21:36

|Well here's what's curious...
|Notice the changing SID-serial# with the same sql address and hash.
|Notice how elapsed seconds gyrates. Elapsed seconds goes from zero to
|447,507,719 yet there were only a few seconds between the queries.
  How can a
|
|session with 447,507,719 seconds of elapsed time suddenly appear???
  Why are
|there sessions going back to November when the computer hasn't even
  been up
|that long? None of the sessions in V$SESSION_LONGOPS are in
  V$SESSION. The
|sql
|address and hash is not extant in V$SQL, V$SQLAREA, etc. Is this view
|supposed to behave this way?
|

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com   --
  Author: Jonathan Lewis
    INET: jonathan_at_jlcomp.demon.co.uk

  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).

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com   --
  Author: Mark Leith
    INET: mark_at_cool-tools.co.uk

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

This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received
this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.

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 Wed Mar 13 2002 - 09:28:31 CST