 |
|
resumable_timeout tips
Oracle Tips by Burleson |
Oracle resumable_timeout
resumable_timeout
Parameter type – Integer
Default value – 0 (seconds)
Modifiable – ALTER SESSION, ALTER SYSTEM
Range of values – 0 to unlimited (in seconds)
resumable_timeout enables or disables resumable
statements and specifies resumable timeout at the system level.
Setting the resumable_timeout initialization
parameter, you can enable resumable space allocation system wild and
specify a timeout interval by setting the resumable_timeout
initialization parameter.
For example, the following setting of the
resumable_timeout parameter in the initialization parameter file
causes all sessions to initially be enabled for resumable space
allocation and sets the timeout period to one hour:
RESUMABLE_TIMEOUT = 3600
If this parameter is set to 0, then resumable
space allocation is disabled initially for all sessions. This is the
default.
You can use the ALTER SYSTEM SET statement to
change the value of this parameter at the system level. For example,
the following statement will disable resumable space allocation for
all sessions:
ALTER SYSTEM
SET RESUMABLE_TIMEOUT=0;
Within a session,
a user can issue the ALTER SESSION SET statement to set the
resumable_timeout initialization parameter and enable resumable
space allocation, change a timeout value, or to disable resumable
mode.
Using ALTER SESSION to enable and disable
Resumable Space Allocation, a user can enable the resumable mode for
a session, using the following SQL statement:
ALTER SESSION
ENABLE RESUMABLE;
To disable the resumable mode, a user issues
the following statement:
ALTER SESSION
DISABLE RESUMABLE;
|