042-007
来源:互联网 发布:sublime text 3 c语言 编辑:程序博客网 时间:2024/05/05 01:12
7: The UNDO_RETENTION parameter in yourdatabase is set to 1000 and undo retention is not guaranteed.Which statementregarding retention of undo data is correct?
A. Undo data becomes obsolete after 1,000 seconds.
B. Undo data gets refreshed after every 1,000 seconds.
C. Undo data will be stored permanently after 1,000 seconds.
D. Committed undo data would be retained for 1,000 seconds if free undo space is available.
E. Undo data will be retained in the UNDO tablespace for 1,000 seconds,then it gets moved to the TEMPORARY tablespace to provide read consistency.
Property Description
900
ModifiableALTER SYSTEM
Range of values0
to 232 - 1 (max value represented by 32 bits)Real Application ClustersOracle recommends that multiple instances have the same value.UNDO_RETENTION
specifies (in seconds) the low threshold value of undo retention. For AUTOEXTEND undo tablespaces, the system retains undo for at least the time specified in this parameter, and automatically tunes the undo retention period to satisfy the undo requirements of the queries. For fixed- size undo tablespaces, the system automatically tunes for the maximum possible undo retention period, based on undo tablespace size and usage history, and ignoresUNDO_RETENTION
unless retention guarantee is enabled.
The setting of this parameter should account for any flashback requirements of the system. Automatic tuning of undo retention is not supported for LOBs. The RETENTION value for LOB columns is set to the value of theUNDO_RETENTION
parameter.
The UNDO_RETENTION
parameter can only be honored if the current undo tablespace has enough space. If an active transaction requires undo space and the undo tablespace does not have available space, then the system starts reusing unexpired undo space. This action can potentially cause some queries to fail with a "snapshot too old" message.
The amount of time for which undo is retained for the Oracle Database for the current undo tablespace can be obtained by querying the TUNED_UNDORETENTION
column of the V$UNDOSTAT
dynamic performance view.
D
- 042-007
- 042
- 007
- 007
- 007
- 007
- 007
- 007
- 007
- 042-005
- 042-006
- 考过042
- oracle 认证 042
- 042--51--100
- 042 - dbms_rls.add_policy
- oracle 042(101-130)
- Oracle 1Z0-042
- OCP题目分析(042)
- 服务器主动向android手机端推送消息---------Linux下实现
- hdu 4390 Number Sequence(组合数学+容斥定理)
- 写在“五一”之解析IAR的ILINK链接器icf配置文件
- spring aop获取目标对象的方法对象
- 【算法】——快速排序
- 042-007
- 图像处理职位面试题汇总(2)
- 新浪校园招聘2013.10.30浙大玉泉4教301笔试的前端妹纸,像雾像雨又像风
- OpenJDK源码研究笔记(九)-可恨却又可亲的的异常(NullPointerException)
- 先把国网项目做好!!
- 单循环赛程安排问题
- 毕业设计中 world的应用
- 用==判断String是否相等
- NIO trick and trap NIO的技巧与陷阱