Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g2DHRKg23297 for ; Wed, 13 Mar 2002 12:27:20 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA95521; Wed, 13 Mar 2002 09:20:12 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 00427290; Wed, 13 Mar 2002 07:28:31 -0800 Message-ID: Date: Wed, 13 Mar 2002 07:28:31 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "K Gopalakrishnan" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "K Gopalakrishnan" Subject: RE: Anyone use V$SESSION_LONGOPS ??? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0018_01C1CAD1.A840A8F0" ------=_NextPart_000_0018_01C1CAD1.A840A8F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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@fatcity.com [mailto:root@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@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 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@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@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@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@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. ========================================================= ------=_NextPart_000_0018_01C1CAD1.A840A8F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Anyone use V$SESSION_LONGOPS ???
John:
 
These=20 are not reposts.. Infact one of my post (which I have sent long back) = appeared=20 today.
 
Jared:=20 Any ideas?
 
 

Best Regards,
K Gopalakrishnan
Bangalore,=20 INDIA

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

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

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


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

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



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

Possibly this is just a 32-bit/64-bit = misalignment=20
in code - I've seem similar silly numbers = appearing=20
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:=20 Building Efficient Databases


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


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


--
Please see the official = ORACLE-L=20 FAQ: http://www.orafaq.com
-- =
Author: Jonathan Lewis
 =20 INET: jonathan@jlcomp.demon.co.uk

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

--
Please see the official = ORACLE-L=20 FAQ: http://www.orafaq.com
-- =
Author: Mark Leith
 =20 INET: mark@cool-tools.co.uk

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



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
This=20 electronic message contains information from the mmO2 plc Group =
which may=20 be privileged or confidential. The information is intended to be =
for the=20 use of the individual(s) or entity named above. If you are not the=20
intended recipient be aware that any disclosure, copying, = distribution or=20
use of the contents of this information is prohibited. If you have = received
this electronic message in error, please notify us by = telephone=20 or email
(to the numbers or address above)=20 = immediately.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
------=_NextPart_000_0018_01C1CAD1.A840A8F0-- _________________________________________________________ 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@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@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).