您当前位置：首页 > 互联网 > OCP试题解析之053-61 RMAN set command id to

OCP试题解析之053-61 RMAN set command id to

来源：程序员人生发布时间：2014-09-09 22:29:29 阅读次数：2969次

61.You frequently have multiple RMAN sessions running, and you want to be able to easily identify each
job via the CLIENTJNFO column of the dynamic performance view V$SESSION. What RMAN command
can you run to set the value for this column?

A. set clientinfo to 'RJB rman session';
B. set command id to 'RJB rman session';
C. set channelid to 'RJB rman session';
D. set session_name to 'RJB rman session

原答案：C

正确答案：B

验证：

RMAN> set command id to 'RJB rman session';

正在执行命令: SET COMMAND ID

SELECT t.SID,t.USERNAME, t.STATUS, t.MACHINE,t.CLIENT_INFO FROM v$session t ORDER BY client_info;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------

SID USERNAME STATUS MACHINE CLIENT_INFO
1 70 SYS INACTIVE WORKGROUPIDYLAN id=RJB rman session

【官方文档】

COMMAND ID TO'string'

Enters the specified string into the V$SESSION.CLIENT_INFO column of all channels. Use this information to determine which Oracle server sessions correspond to which RMAN channels. The SET COMMAND ID command applies only to channels that are already allocated.

The V$SESSION.CLIENT_INFO column contains information for each RMAN server session. The data appears in one of the following formats:

id=string
id=string, ch=channel_id

The first form appears in the RMAN target database connection. The second form appears in all allocated channels. When the current job is complete, the V$SESSION.CLIENT_INFO column will be cleared.

生活不易，码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
程序员人生

------分隔线----------------------------

上一篇 浅谈过载保护

下一篇 直接拿来用！Facebook移动开源项目大合集

分享到:

------分隔线----------------------------

为码而活

积分：4237

15粉丝

7关注

栏目热点