Dubious 1555

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 7 Aug 2006 10:25:22 +0100
Message-ID: <7765c8970608070225h3d42bd5bo445a85758d4d3b87@mail.gmail.com>

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 - 04:25:22 CDT