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.