ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q424(DBA_RESUMABLE)

Oracle OCP 1Z0 053 Q424(DBA_RESUMABLE)

原创 Oracle 作者:abstractcyj 时间:2016-04-02 14:57:06 0 删除 编辑
424.Which of these components correctly identify the unique value of the NAME column in the
DBA_RESUMABLE view?
A. Username, instance number, session ID
B. Instance number, username, session ID
C. Instance number, session ID, username
D. Username, session ID, instance number
E. None of the above
Answer: D

参考:http://docs.oracle.com/cd/E11882_01/server.112/e22490/ldr_params.htm#SUTIL1037
       http://blog.csdn.net/rlhua/article/details/14522445

RESUMABLE_NAME

Default: 'User USERNAME (USERID), Session SESSIONID, Instance INSTANCEID'

The value for this parameter identifies the statement that is resumable. This value is a user-defined text string that is inserted in either the USER_RESUMABLE or DBA_RESUMABLE view to help you identify a specific resumable statement that has been suspended.

This parameter is ignored unless the RESUMABLE parameter is set to true to enable resumable space allocation


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2074181/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091635