ORA-01555: snapshot too old
Hi,
On 12.9 C on AIX
I usually in alert log:
ORA-01555 caused by SQL statement below (SQL ID: 1mqmjqk6, Query Duration=9247 sec
In which I see query Duration. And I adjust retention parameter accordingly.
But this morning I have:
:ORA-01555 caused by SQL statement below (SQL ID: 7ardu1cp6, Query Duration=0 sec,
Can anyone explain me why in this message I have zero duration and how adjust retention time for this case?
Thank you.