RE: Record breaking query

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