OCP 1Z0 053 266
来源:互联网 发布:网络优化工程师 编辑:程序博客网 时间:2024/06/05 17:22
266.View the Exhibit to examine the parameters set for your database instance. You execute the following
command to perform I/O calibration after the declaration of bind variables in the session that are used in
the command:
SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, - max_latency=>50,
-max_iops=>:max_iops, -max_mbps=>:max_mbps, -
actual_latency=>:actual_latency);
Which statement describes the consequence?
A. The command produces an error.
B. The calibration process runs successfully and populates all the bind variables.
C. The calibration process runs successfully but the latency time is not computed.
D. The calibration process runs successfully but only the latency time is computed.
Answer: A
http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_resmgr.htm#ARPLS050
Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on
command to perform I/O calibration after the declaration of bind variables in the session that are used in
the command:
SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, - max_latency=>50,
-max_iops=>:max_iops, -max_mbps=>:max_mbps, -
actual_latency=>:actual_latency);
Which statement describes the consequence?
A. The command produces an error.
B. The calibration process runs successfully and populates all the bind variables.
C. The calibration process runs successfully but the latency time is not computed.
D. The calibration process runs successfully but only the latency time is computed.
Answer: A
http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_resmgr.htm#ARPLS050
Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on
timed_statistics
, and ensure asynch_io
is enabled for datafiles. This can be achieved by setting filesystemio_options
to either ASYNCH
or SETALL
. One can also query the asynch_io
status by means of the following SQL statement:SQL> alter session set statistics_level = basic;会话已更改。SQL> alter session set timed_statistics = false;会话已更改。SQL> SET SERVEROUTPUT ONSQL> DECLARE 2 lat INTEGER; 3 iops INTEGER; 4 mbps INTEGER; 5 BEGIN 6 -- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<DISKS>, <MAX_LATENCY>, iops, mbps, lat); 7 DBMS_RESOURCE_MANAGER.CALIBRATE_IO (1, 50, iops, mbps, lat); 8 9 DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops); 10 DBMS_OUTPUT.PUT_LINE ('latency = ' || lat); 11 DBMS_OUTPUT.PUT_LINE ('max_mbps = ' || mbps); 12 end; 13 /DECLARE*第 1 行出现错误:ORA-56709: timed_statistics 已设置为 FALSEORA-06512: 在 "SYS.DBMS_RMIN", line 463ORA-06512: 在 "SYS.DBMS_RESOURCE_MANAGER", line 1302ORA-06512: 在 line 7
0 0
- OCP 1Z0 053 266
- OCP 1Z0 053 1
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- OCP 1Z0 053 16
- OCP 1Z0 053 17
- Viewport及Window
- ASP.NET 安全认证(一)—— 如何运用 Form 表单认证
- 【Android】开发小经验1
- Jobdu 题目1017:还是畅通工程
- DevStore独家开放-智游推送开源安卓版SDK
- OCP 1Z0 053 266
- Functional Reactive Programming
- C++类型转换
- 信息论的熵
- 原来wifi,有史以来……
- 奖谷歌眼镜,七牛云存储Demo征集大赛等你挑战
- UTF8-GBK转换
- 二叉树中序遍历非递归算法(C/C++语言实现)
- SQL server 数据库的版本为661,无法打开,此服务器只支持655版及更低版本。不支持降级路径