RE: Record breaking query

I know what the message says. Do you believe everything you see printed? Or expressing is differently: how many error/diagnostics messages have you seen that are more misleading than helpful.

At 01:24 PM 8/8/2003 -0800, you wrote:

>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-----
>From: Wolfgang Breitling
>[<mailto:breitliw_at_centrexcc.com>mailto:breitliw_at_centrexcc.com]
>Sent: Friday, August 08, 2003 4:04 PM
>To: Multiple recipients of list ORACLE-L
>Subject: 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>http://www.orafaq.net
> >--
> >Author: Jesse, Rich
> > INET: Rich.Jesse_at_qtiworld.com
> >
> >Fat City Network Services -- 858-538-5051
> <http://www.fatcity.com>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>http://www.centrexcc.com
>
>--
>Please see the official ORACLE-L FAQ:
><http://www.orafaq.net>http://www.orafaq.net
>--
>Author: Wolfgang Breitling
> INET: breitliw_at_centrexcc.com
>
>Fat City Network Services -- 858-538-5051
><http://www.fatcity.com>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).