Which is possible reason for this?

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?

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?

A.
The Oracle server is unable to generate a read-consistent image for a block containing updates.committed
after the query began.

B.
The query is unable to place data blocks in the UNDO tablespace.

C.
The flashback data archive is not enabled for the table on which the query is issued.

D.
There is not enough space in Fast Recovery Area.

E.
The Oracle server is unable to generate a read-consistent image for a block containing uncommitted
updates.

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Mike

Mike

I think A.
not B – would not generate snapshot to old error
not CD makes no sense
not E – uncommited blocks are still ACTVIE undo, so they cannot be overwritten (so no snapshot to old)

Reply

Diego

Diego

Should be A

Reply