WOW! How many googolbytes do you have devoted to your Undo Tablespaces?
> "Jamadagni, Rajendra" wrote:
>
> 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
> --------------------------------------------------------------------------------
> 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 !
>
> Name: ESPN_Disclaimer.txt
> ESPN_Disclaimer.txt Type: Plain Text (text/plain)
> Encoding: 7bit
begin:vcard
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;;;;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel W. Fink
end:vcard