Default: 'User USERNAME(USERID), Session SESSIONID, Instance INSTANCEID'
Purpose
The RESUMABLE_NAME parameter identifies a statement that is resumable.
Syntax and Description
RESUMABLE_NAME='text_string'
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.
Restrictions
This parameter is ignored unless the RESUMABLE parameter is set to TRUE to enable resumable space allocation.
Example
RESUMABLE_NAME='my resumable sql'