整理:
1. 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. The query runs for more than 15 minutes and then SCOTT receives the
following 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
快照过旧:
ORA-01555 快照过旧,是数据库中很常见的一个错误,比如当我们的事务需要使用undo来构建CR块的时候,而此时对应的undo已经不存在了,这个时候就会报ORA-01555的错误。
一般是由于,SQL语句执行时间太长,或者undo表空间过小,或者事务量过大,或者过于频繁的提交,导致执行SQL过程中进行一致性读时,SQL执行后修改的前镜像(既UNDO数据)在UNDO表空间中已经被覆盖,不能构造一致性读块(CR blocks)
A.正确。B.错误,闪回恢复区的空间跟快照过旧没有关系。C.错误,闪回归档的空间大小跟快照过旧没有关系。D.错误,query产出的事务大量在undo段中产生undo数据,覆盖了已有的undo数据,才会造成快照过旧。所以D错误。
1. View the Exhibit and examine the attributes of an undo tablespace.
![](http://img.blog.itpub.net/blog/attachment/201410/16/16775237_1413443904pRtz.png?x-oss-process=style/bb)
In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour
that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the
following 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
快照过旧:
ORA-01555 快照过旧,是数据库中很常见的一个错误,比如当我们的事务需要使用undo来构建CR块的时候,而此时对应的undo已经不存在了,这个时候就会报ORA-01555的错误。
一般是由于,SQL语句执行时间太长,或者undo表空间过小,或者事务量过大,或者过于频繁的提交,导致执行SQL过程中进行一致性读时,SQL执行后修改的前镜像(既UNDO数据)在UNDO表空间中已经被覆盖,不能构造一致性读块(CR blocks)
A.正确。B.错误,闪回恢复区的空间跟快照过旧没有关系。C.错误,闪回归档的空间大小跟快照过旧没有关系。D.错误,query产出的事务大量在undo段中产生undo数据,覆盖了已有的undo数据,才会造成快照过旧。所以D错误。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16775237/viewspace-1300791/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16775237/viewspace-1300791/