Re: Dubious 1555
- From: "Daniel W. Fink" <danielwfink@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Mon, 07 Aug 2006 07:18:40 -0600
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
Other related posts:
