View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts…

Oracle enforces statement-level read consistency by using undo segments to reconstruct the version of a data block as it existed at the query's start SCN. During peak bulk-insert activity, undo extents are rapidly reused and overwritten, and if the undo needed to roll back a block to the query's start SCN is gone, Oracle raises ORA-01555 because it can no longer provide a consistent read image.

The Flash Recovery Area is a disk location used for backup and recovery files such as archived logs and RMAN backups; it has no role in undo retention or statement-level read consistency.

A flashback archive stores historical row versions for Flashback Data Archive queries and is a separate feature from the undo tablespace used for read consistency - its space constraints do not cause ORA-01555.

ORA-01555 is caused by the inability to reconstruct an old read-consistent image from undo data, not by a failure to write new undo data blocks; the error indicates undo has been overwritten, not that there is no space to place new undo.