Re: Dubious 1555
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Aug 2006 04:05:28 -0700 (PDT)
Does v$undostat report the same time period ?.
what version of oracle.9.2.0.X
----- Original Message ----
From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, August 7, 2006 4:25:22 AM
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
Other related posts:
