RE: Dubious 1555

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Mon, 7 Aug 2006 08:38:45 -0700
Message-ID: <00d401c6ba37$92cf13d0$6c01a8c0@flbp7000a>

Niall,

That query ran longer than I have been alive! Another good place to look for SQL that might be gone from the SQL area is in dba_hist_sqltext (and the plan in dba_hist_sql_plan).

Obviously those durations are a bug. That's the first time I've seen it.

Jeremiah

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Monday, August 07, 2006 2:25 AM
To: Oracle Discussion List
Subject: Dubious 1555

All

We have a number of 1555's in the alert log over the weekend. However I don't entirely believe the duration, since the query apparently dates from before Oracle was invented

ORA-01555 caused by SQL statement below (SQL ID: dsphq1qsnymv8, Query Duration=1154655032 sec, SCN: 0x0000.dd9542ce):

I don't get any rows returned when I query v$sql on the above sql_id. (the sql id is always the same). Anyone else seen these ludicrous durations?

--

Niall Litchfield
Oracle DBA
http://www.orawin.info

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 07 2006 - 10:38:45 CDT