OCP 1Z0 052 30
来源:互联网 发布:外星人源码eenot 编辑:程序博客网 时间:2024/06/11 10:42
30. In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?
A.when the data file of the undo tablespace is autoextensible
B.when there are more than one undo tablespaces available in the database
C.when the undo tablespace is of a fixed size and retention guarantee is not enabled
D.when the undo tablespace is autoextensible and retention guarantee is not enabled
Answer: C
A.when the data file of the undo tablespace is autoextensible
B.when there are more than one undo tablespaces available in the database
C.when the undo tablespace is of a fixed size and retention guarantee is not enabled
D.when the undo tablespace is autoextensible and retention guarantee is not enabled
Answer: C
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 ignores UNDO_RETENTION unless retention guarantee is enabled.
1、设置为自增时,将最大限度的保留undo,以供查询所需要
2、非自增时,同时最大限度的保留。但因空间有限,当空间不够时就没个么好说的了,先拿来用吧,除非设定guarantee 。
0 0
- OCP 1Z0 052 30
- OCP 1Z0 052 1
- OCP 1Z0 052 2
- OCP 1Z0 052 3
- OCP 1Z0 052 4
- OCP 1Z0 052 5
- OCP 1Z0 052 6
- OCP 1Z0 052 7
- OCP 1Z0 052 8
- OCP 1Z0 052 9
- OCP 1Z0 052 10
- OCP 1Z0 052 11
- OCP 1Z0 052 12
- OCP 1Z0 052 13
- OCP 1Z0 052 14
- OCP 1Z0 052 15
- OCP 1Z0 052 16
- OCP 1Z0 052 17
- 产品设计:Android应用-开发技术【数据缓存】
- cURL(优秀的应用层网络协议库)
- 当spring 容器初始化完成后执行某个方法
- FHTDJoWfKpytfWl
- 解决:Linux屏幕锁定后输入密码无法进入桌面
- OCP 1Z0 052 30
- 插件开发
- android显示隐藏控件
- Powershell远程在Azure A7虚拟机运行Java JVM失败
- 发生的HBV
- 语录
- select, iocp, epoll,kqueue及各种I/O复用机制
- Oracle学习路线
- 阿飞发松岛枫