本文探讨了如何正确识别DBA_RESUMABLE视图中NAME列的唯一值，指出正确的组合为Username, sessionID, instancenumber，并解释了RESUMABLE_NAME参数的作用及其默认设置。
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#SUTIL1039
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 orDBA_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.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
