RE: Record breaking query

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 08 Aug 2003 13:24:24 -0800
Message-ID: <F001.005C9AEB.20030808132424@fatcity.com>

but message says it is in seconds ... anf yes it is 92 ...

Thanks
Raj

---

---

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
Sent: Friday, August 08, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L

Is that an Oracle 9 system and the time is in microseconds rather than seconds?

At 10:39 AM 8/8/2003 -0800, you wrote:
>Yeah, but think of the uptime! One helluva MTBF on that server...
>
>Rich
>
>Rich Jesse System/Database Administrator
>rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
>
>-----Original Message-----
>Sent: Friday, August 08, 2003 12:49 PM
>To: Multiple recipients of list ORACLE-L
>
>
>TICK : Fri Aug 8 09:06:03 2003
>SEARCH in kdisti: tsn = 5, objd = 83525, rdba = 33588489
>ORA-01555 caused by SQL statement below (Query Duration=1060347963 sec,
SCN:
>0x0011.05e003c2):
>TICK : Fri Aug 8 09:06:03 2003
>SELECT VOBJID, VNAME, VTEXT, VLEN, VOWNER, VOWNERID, VAUDIT, VCOMMENT,
>VCNAME, PROPERTY, DEFER, FLAGS, OIDLEN, OIDCLAUSE, TYPEOWNER,
>TYPENAME, UNDERLEN, UNDERCLAUSE FROM SYS.EXU8VEW WHERE
VOWNERID
>!= :"SYS_B_0" ORDER BY VLEVEL, VOWNER, VOBJID
>according to this error message this query has been running for close to 33
>years. appears to be a export running for 33 years.
>I am clusless
>Raj
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Fri Aug 08 2003 - 16:24:24 CDT