OCP-1Z0-052-V8.02-1题
来源:互联网 发布:怎么去 成都知美术馆 编辑:程序博客网 时间:2024/04/28 04:03
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
Answer: A
答案解析:
参考:管理还原数据:http://blog.csdn.net/rlhua/article/details/12259555
“快照太旧”错误是因为没有足够的还原数据来实现读取一致性。所以选A。
- ORA-01555: snapshot too old: rollback segment number string with name "string" too small
- Cause: rollback records needed by a reader for consistent read are overwritten by other writers
- Action: If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments
- OCP-1Z0-052-V8.02-1题
- OCP-1Z0-052-V8.02-91题
- OCP-1Z0-052-V8.02-92题
- OCP-1Z0-052-V8.02-80题
- OCP-1Z0-052-V8.02-81题
- OCP-1Z0-052-V8.02-82题
- OCP-1Z0-052-V8.02-79题
- OCP-1Z0-052-V8.02-77题
- OCP-1Z0-052-V8.02-23题
- OCP-1Z0-052-V8.02-72题
- OCP-1Z0-052-V8.02-157题
- OCP-1Z0-052-V8.02-156题
- OCP-1Z0-052-V8.02-155题
- OCP-1Z0-052-V8.02-29题
- OCP-1Z0-052-V8.02-110题
- OCP-1Z0-052-V8.02-165题
- OCP-1Z0-052-V8.02-171题
- OCP-1Z0-052-V8.02-170题
- 使用cxf做Webservice接口时,返回值不能是Map或List等接口
- hdu 4455 Substrings (经典DP)
- 声名与定义的区别
- [Google] LRU cache实现
- 菜鸟,我拿什么来博客?
- OCP-1Z0-052-V8.02-1题
- MyEclipse 8.5 安装配置指南
- UVaOJ
- 融入电商大潮的八条靠谱建议
- 谈谈我网络分层协议的理解和问题
- huawei交换机典型配置
- php超长文本的分页
- 求AOE网的关键路径
- java之线程thread生命周期