Managing Database Resources - OCP: Oracle Database 12c Administrator Certified Professional - page 458

For parallel operations, each process is handled independently. If one sus-
pends, an error is logged and the associated AFTER SUSPEND trigger, if any,
is executed. Meanwhile, the other parallel processes continue. However, if
one aborts, the parallel operation aborts. As with all resumable process-
ing, when a suspend condition is repaired, it will continue and join up with
the others.
Enabling and Disabling Resumable Operations
You enable resumable operations and configure the suspend time-out for the instance and
for a session. For the instance, configure the initialization parameter RESUMABLE_TIMEOUT .
For the session, set the session parameter RESUMABLE_TIMEOUT to a numeric value greater
than zero, or issue the ALTER SESSION command.
Enabling and Disabling Resumable Operations for an Instance
To enable resumable operations for the instance, alter the instance parameter RESUMABLE_
TIMEOUT to a numeric value greater than zero. The default value is 0, which in effect ini-
tially disables resumable operations for all sessions. This represents the number of seconds
that an operation may suspend while you take corrective action. After the time-out is
reached, the operation will abort. In this example, we alter the system RESUMABLE_TIMEOUT
from 1 minute to 10 minutes:
SQL> show parameter resumable
NAME TYPE VALUE
------------------------------------ ----------- -------
resumable_timeout integer 60
SQL> alter system set resumable_timeout=600 scope=both;
System altered.
Enabling and Disabling Resumable Operations for a Session
Before you can enable or disable resumable operations at the session level, the user must
have been granted the RESUMABLE system privilege. Once that's granted, resumable
operations are enabled within a session when the following command is issued:
SQL> alter session enable resumable;
Session altered.