Oracle OCP 1Z0 053 Q424(DBA_RESUMABLE)

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部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2074181/，如需轉載，請註明出處，否則將追究法律責任。