RE: Anyone use V$SESSION_LONGOPS ???
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: [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). winmail.dat
Re: Anyone use V$SESSION_LONGOPS ???
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 [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). winmail.dat
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 [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).
RE: Anyone use V$SESSION_LONGOPS ???
No... it's Deja vu all over again. Yogi Berra -Original Message- Sent: Wednesday, March 13, 2002 5:53 AM 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 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 [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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).
RE: Anyone use V$SESSION_LONGOPS ???
Title: 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.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 [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. =
RE: Anyone use V$SESSION_LONGOPS ???
Title: 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 GopalakrishnanBangalore, INDIA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hallas JohnSent: Wednesday, March 13, 2002 6:49 AMTo: Multiple recipients of list ORACLE-LSubject: 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.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 [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.=
RE: Anyone use V$SESSION_LONGOPS ???
Title: 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-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 13, 2002 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: 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.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 [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.=
Re: Anyone use V$SESSION_LONGOPS ???
I think this same question was asked last week, wasn't it? Check the archives, there was an explanation. Jared Orr, Steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/13/02 12:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Anyone use V$SESSION_LONGOPS ??? 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.) col SID-ser# format a10 col secs format 999,999,999 heading Elapsed|Seconds col addhash format a15 heading SQL Address|Hash select substr(lo.sid||'-'||lo.serial#,1,10) SID-Ser#, lo.last_update_time Last Update, lo.elapsed_seconds secs, lo.sql_address||'-'||lo.sql_hash_value addhash fromv$session_longops lo where lo.username not like 'SYS%' / Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 73-259303/07/2002 11:39:54 447,507,594 56B9FA30-792775 SQL/ Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 51-61397 03/07/2002 11:40:520 56B9FA30-792775 SQL/ Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 63-34890 03/07/2002 11:41:59 447,507,719 56B9FA30-792775 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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). winmail.dat Description: Binary data
RE: Anyone use V$SESSION_LONGOPS ???
What I like are the responses with todays date that match the original question dated March 07. The answer was exactly the same answer just a new date. Somebody justifying work by count(emails)?? ex:#dated 03/13/2002 11:03 AM Yes, the man is a X$ marvel What that I could remember all of the things that he seems to have at the tip of his emails. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 07, 2002 7:18 PM To: Multiple recipients of list ORACLE-L To give credit where credit is due, this came from my friend K Gopalakrishnan... You mean K 'X$' Gopalakrishnan, don't you ;-) John Kanagaraj ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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).
RE: Anyone use V$SESSION_LONGOPS ???
Perhaps someone has picked up a virus that is picking up old mail and resending it... :-)) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Wednesday, March 13, 2002 1:55 PM To: Multiple recipients of list ORACLE-L What I like are the responses with todays date that match the original question dated March 07. The answer was exactly the same answer just a new date. Somebody justifying work by count(emails)?? ex:#dated 03/13/2002 11:03 AM Yes, the man is a X$ marvel What that I could remember all of the things that he seems to have at the tip of his emails. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 07, 2002 7:18 PM To: Multiple recipients of list ORACLE-L To give credit where credit is due, this came from my friend K Gopalakrishnan... You mean K 'X$' Gopalakrishnan, don't you ;-) John Kanagaraj ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Freeman, Robert 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).
RE: Anyone use V$SESSION_LONGOPS ???
Steve, Hmmm doesn't look right as KG pointed out, might be a bug ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! winmail.dat
RE: Anyone use V$SESSION_LONGOPS ???
No, not a clue. I'll see what I can find out. Jared K Gopalakrishnan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/13/02 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: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- Sent: Wednesday, March 13, 2002 6: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- 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 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 [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. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Anyone use V$SESSION_LONGOPS ???
No it is not broken, unless someone explicitly updates underlying information it is not visible I monitor this when I am creating or rebuilding indexes to importing ... at that time Oracle will populate relevant fields, and that is really useful. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: Anyone use V$SESSION_LONGOPS ???
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: [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).
RE: Anyone use V$SESSION_LONGOPS ???
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? -Original Message- No it is not broken, unless someone explicitly updates underlying information it is not visible I monitor this when I am creating or rebuilding indexes to importing ... at that time Oracle will populate relevant fields, and that is really useful. Raj __ Rajendra Jamadagni MIS, ESPN Inc. -Original Message- Sent: Thursday, March 07, 2002 1: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.) col SID-ser# format a10 col secs format 999,999,999 heading Elapsed|Seconds col addhash format a15 heading SQL Address|Hash select substr(lo.sid||'-'||lo.serial#,1,10) SID-Ser#, lo.last_update_time Last Update, lo.elapsed_seconds secs, lo.sql_address||'-'||lo.sql_hash_value addhash fromv$session_longops lo where lo.username not like 'SYS%' / Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 73-259303/07/2002 11:39:54 447,507,594 56B9FA30-792775 SQL/ Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 51-61397 03/07/2002 11:40:520 56B9FA30-792775 SQL/ Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 63-34890 03/07/2002 11:41:59 447,507,719 56B9FA30-792775 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Orr, Steve 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).
Re: Anyone use V$SESSION_LONGOPS ???
I see what you're concerned about. The recent sessions' operations are getting aged out of v$session_longops almost as soon as they are done, and there are a bunch of old sessions' operations sitting around in there from last November. Looking at some of my systems, I see a couple stragglers from long ago sitting in there, but it doesn't seem to be hurting anything. Yours does look a little broken. The entries in v$session_longops should survive beyond the session disconnecting. Note that you are cutting off your sql hash value with the column command and also combining it with SQL Address, which is why it doesn't match anything. In general though, it looks like your v$session_longops is correctly displaying long operations as they are occurring, which is what most people watch v$session_longops for. Does anyone know what governs how long entries in v$session_longops are preserved? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 7 Mar 2002, Orr, Steve wrote: 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.) col SID-ser# format a10 col secs format 999,999,999 heading Elapsed|Seconds col addhash format a15 heading SQL Address|Hash select substr(lo.sid||'-'||lo.serial#,1,10) SID-Ser#, lo.last_update_time Last Update, lo.elapsed_seconds secs, lo.sql_address||'-'||lo.sql_hash_value addhash fromv$session_longops lo where lo.username not like 'SYS%' / Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 73-259303/07/2002 11:39:54 447,507,594 56B9FA30-792775 SQL/ Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 51-61397 03/07/2002 11:40:520 56B9FA30-792775 SQL/ Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 63-34890 03/07/2002 11:41:59 447,507,719 56B9FA30-792775 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
RE: Anyone use V$SESSION_LONGOPS ???
Steve, Hmmm doesn't look right as KG pointed out, might be a bug ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: Anyone use V$SESSION_LONGOPS ???
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 [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).
RE: Anyone use V$SESSION_LONGOPS ???
Here's what I just got from OWS: After further research, this is a known issue that has development feed back as follows: BUG:1348362 'SQL EXECUTION' INFORMATION IN V$SESSION_LONGOPS IS INACCURATE WHEN SORTING Status: 92,Closed, Not a Bug This is not a bug.. it is expected behaviour. As PQ relies on several slave processes to complete their partial work and report the statistics, and a co-ordinator to aggregate them and update the statistics, it is inherent in PQ execution model that updates to statistics is not smooth and in some particular cases it is possible that execution is 100% complete before updates are made. So I think it should be treated as limition of our PQ architecture rather than as a bug. Any attempt to guaruntee the smoothness of progress of 'SQL Execution' operation will call for change in design and architecture of PQ execution model. So I would treat this as not a bug, but a limitation which can not be fixed. NOW THAT WAS ENTERTAINING!!! :-) Oracle Customer: Looks like a bug, walks like a bug, talks like a bug... Oracle Support: No, it's really just another innocuous insect. Steve Orr -Original Message- Sent: Thursday, March 07, 2002 2:13 PM To: '[EMAIL PROTECTED]' 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? -Original Message- No it is not broken, unless someone explicitly updates underlying information it is not visible I monitor this when I am creating or rebuilding indexes to importing ... at that time Oracle will populate relevant fields, and that is really useful. Raj __ Rajendra Jamadagni MIS, ESPN Inc. -Original Message- Sent: Thursday, March 07, 2002 1: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.) col SID-ser# format a10 col secs format 999,999,999 heading Elapsed|Seconds col addhash format a15 heading SQL Address|Hash select substr(lo.sid||'-'||lo.serial#,1,10) SID-Ser#, lo.last_update_time Last Update, lo.elapsed_seconds secs, lo.sql_address||'-'||lo.sql_hash_value addhash fromv$session_longops lo where lo.username not like 'SYS%' / Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 73-259303/07/2002 11:39:54 447,507,594 56B9FA30-792775 SQL/ Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 51-61397 03/07/2002 11:40:520 56B9FA30-792775 SQL/ Elapsed SQL Address SID-Ser# Last Update Seconds Hash -- --- --- 30-602111/28/2001 23:20:21 77 095B5B94-0 30-602111/28/2001 23:21:35 74 095B5B94-0 30-602111/28/2001 23:22:21 46 095B5B94-0 30-602111/28/2001 23:23:24 62 095B5B94-0 30-602111/28/2001 23:24:26 62 095B5B94-0 24-343511/28/2001 23:59:309 59D39B8C-363345 30-711011/29/2001 00:40:219 59D39B8C-363345 63-34890 03/07/2002 11:41:59 447,507,719 56B9FA30-792775 --
