RE: Anyone use V$SESSION_LONGOPS ???

Man! I'm glad somebody else said something.  

I was frantically adjusting my medication.....  

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, March 13, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L

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

-----Original Message-----
<mailto:mark_at_cool-tools.co.uk> ]
Sent: 13 March 2002 12:53
To: Multiple recipients of list ORACLE-L

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 <http://www.jlcomp.demon.co.uk>

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html <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 <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
<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
<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 
-------------------------------------------------------------------- 
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). 



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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: Thomas.Mercadante_at_Labor.State.Ny.Us

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