OCP-1Z0-053-V12.02-422题

设置RESUMABLE_TIMEOUT参数

最新推荐文章于 2021-04-05 07:16:37 发布

原创最新推荐文章于 2021-04-05 07:16:37 发布 · 4.5k 阅读

1 ·

CC 4.0 BY-SA版权

OCP11g解析同时被 2 个专栏收录

870 篇文章

订阅专栏

OCP-1Z0-053

796 篇文章

订阅专栏

本文介绍如何通过设置RESUMABLE_TIMEOUT初始化参数来启用Oracle数据库实例的可恢复空间分配功能。该参数允许管理员指定默认的系统级超时间隔。

422.To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?

A. RESUMABLE_SPACE_TIME

B. RESUMABLE_SPACE

C. RESUMABLE_TIME

D. RESUMABLE_TIMEOUT

E. TIME_RESUMABLE

Answer: D

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN11589

Setting the RESUMABLE_TIMEOUT Initialization Parameter

You can specify a default system wide timeout interval by setting the RESUMABLE_TIMEOUT initialization parameter. For example, the following setting of theRESUMABLE_TIMEOUT parameter in the initialization parameter file sets the timeout period to 1 hour:

RESUMABLE_TIMEOUT = 3600

If this parameter is set to 0, then resumable space allocation is disabled even for sessions that run an ALTER SESSION ENABLE RESUMABLE statement without a timeout value.

You can also use the ALTER SYSTEM SET statement to change the value of this parameter at the system level. For example, the following statement disables resumable space allocation for all sessions that run an ALTER SESSION ENABLE RESUMABLE statement without a timeout value:

ALTER SYSTEM SET RESUMABLE_TIMEOUT=0;