Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Hallas John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 9: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:[EMAIL PROTECTED]]
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.ukNext Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.htmlHost to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlAuthor of:
Practical Oracle 8i: Building Efficient Databases
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]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: [EMAIL PROTECTED] (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.
=========================================================
