Database Reference
In-Depth Information
If you do not set a specific value for RESUMABLE_TIMEOUT for the instance or when
enabling resumable for a session, the default value for a session is 7,200 seconds. To disable
resumable operations within a session, issue the following command:
SQL> alter session disable resumable;
Session altered.
Additionally, the user session can control the suspend time-out in one of three ways:
by altering the RESUMABLE_TIMEOUT parameter for the session, by executing the DBMS_
RESUMABLE.SET_TIMEOUT procedure (covered later, in the section “The DBMS_RESUMABLE
Supplied Package”), or by appending to the ALTER SESSION ENABLE RESUMABLE command
as follows:
SQL> alter session set resumable_timeout=3600;
Session altered.
SQL> show parameter resumable;
NAME TYPE VALUE
------------------------------------ ----------- -----
resumable_timeout integer 3600
SQL>
SQL> alter session enable resumable timeout 7200;
Session altered.
SQL> show parameter resumable;
NAME TYPE VALUE
------------------------------------ ----------- -----
resumable_timeout integer 3600
SQL>
The ALTER SESSION ENABLE RESUMABLE TIMEOUT NNNN command does not alter the
value of the session-initialization parameter RESUMABLE_TIMEOUT .
Procedurally, you can also enable resumable operations for a session with a logon trigger.
Search WWH ::




Custom Search