Re: Dubious 1555

From: Daniel W. Fink <danielwfink_at_yahoo.com>
Date: Mon, 07 Aug 2006 07:18:40 -0600
Message-ID: <44D73DB0.9090603@yahoo.com>

Niall,

These durations are not uncommon. I have seen them pretty consistently on a couple of 10g databases, but I've never discerned the reason. Are these queries coming across database links by any chance?

Regards,
Daniel Fink

Niall Litchfield wrote:
> 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 - 08:18:40 CDT