Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h78LtCW24374 for ; Fri, 8 Aug 2003 16:55:12 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h78LtAp24369 for ; Fri, 8 Aug 2003 16:55:10 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h78JVST09899 for oracle-l@orafaq.net; Fri, 8 Aug 2003 12:31:28 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C9AD0; Fri, 08 Aug 2003 12:19:23 -0800 Message-ID: Date: Fri, 08 Aug 2003 12:19:23 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Jamadagni, Rajendra" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Jamadagni, Rajendra" Subject: RE: Record breaking query Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-7011c449-26a6-4279-a828-30fffe8884f8" ------=_NextPartTM-000-7011c449-26a6-4279-a828-30fffe8884f8 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C35DE2.45EDA711" ------_=_NextPart_001_01C35DE2.45EDA711 Content-Type: text/plain; charset="iso-8859-1" 12GB only 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 2:09 PM To: Multiple recipients of list ORACLE-L 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 ------_=_NextPart_001_01C35DE2.45EDA711 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Record breaking query

12GB only

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: Daniel Fink [mailto:daniel.fink@sun.com]
Sent: Friday, August 08, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Record breaking query


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 =3D 5, objd =3D 83525, = rdba =3D 33588489
> ORA-01555 caused by SQL statement below (Query = Duration=3D1060347963 sec, SCN: 0x0011.05e003c2):
> TICK : Fri Aug  8 09:06:03 2003
> SELECT VOBJID, VNAME, VTEXT, VLEN, VOWNER, = VOWNERID, VAUDIT, = VCOMMENT,          &nb= sp;  VCNAME, PROPERTY, DEFER, FLAGS, OIDLEN, OIDCLAUSE, = TYPEOWNER,          &n= bsp;  TYPENAME, UNDERLEN, = UNDERCLAUSE      FROM   = SYS.EXU8VEW      WHERE  VOWNERID !=3D = :"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

------_=_NextPart_001_01C35DE2.45EDA711-- ------=_NextPartTM-000-7011c449-26a6-4279-a828-30fffe8884f8 Content-Type: text/plain; name="ESPN_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ESPN_Disclaimer.txt" ********************************************************************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 ------=_NextPartTM-000-7011c449-26a6-4279-a828-30fffe8884f8-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni@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@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).