ORA-1555 Error With Query Duration as 0 Seconds
(Doc ID 761128.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.
ORA-1555 error reported intermittently with query duration as 0 seconds.
This may be impacted by <bug:5475085> which identified that not all undo statistics are being updated when they should be, such as V$UNDOSTAT.EXPBLKREUCNT.
Duplicate with Bug <30686017> : UNDO SEGMENT STATS SHOWING ZERO REUSE EVEN WITH AUTOTUNE AND ORA-01555
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document