You are administering a database that supports an OLTP workload.
The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo
retention set to 12 minutes.
The user SCOTT queries a large table during peak activity.
The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old
Which is possible reason for this?
The Oracle server is unable to generate a read-consistent image for a block containing updates.committed
after the query began.
The query is unable to place data blocks in the UNDO tablespace.
The flashback data archive is not enabled for the table on which the query is issued.
There is not enough space in Fast Recovery Area.
The Oracle server is unable to generate a read-consistent image for a block containing uncommitted