问题:
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 hourthat performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives thefollowing error:
ORA-01555: snapshot too old
What could be the reason for this error()
A . The query is unable to get a read-consistent image.
B . There is not enough space in Flash Recovery Area.
C . There is not enough free space in the flashback archive.
D . The query is unable to place data blocks in undo tablespace
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 hourthat performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives thefollowing error:
ORA-01555: snapshot too old
What could be the reason for this error()
● 参考解析
快照太旧错误是因为没有足够的还原数据来实现读取一致性。所以选A。
相关内容
相关标签