Database Reference
In-Depth Information
The DBMS_RESUMABLE Supplied Package
The DBMS_RESUMABLE package allows you to get and set time-out parameters for a session,
abort a suspended resumable session, and query the error stack for specific resumable space
errors. TableĀ 10.2 describes the package functions and subprograms.
TABleĀ 10.2 DBMS_RESUMABLE Package Programs
Program Name
Description
ABORT
Procedure that allows you to abort a suspended resumable
operation
GET_SESSION_TIMEOUT
Function that when passed the session ID returns the current
resumable time-out
GET_TIMEOUT
Function that returns resumable time-out for the current session
SET_SESSION_TIMEOUT
Procedure that when passed the session ID and time-out value
sets the time-out for a session
SET_TIMEOUT
Procedure that sets the time-out for the current session
SPACE_ERROR_INFO
Function that allows you to search the error stack on error_
type , object_type , object_owner , object_name , sub_object_
name , and table_space_name
In the following code, you see an example that enables resumable for the session; gets the
session time-out value; changes the value; queries the value; disables resumable; and then
queries, modifies, and enables it. You'll note that the resumable time-out value is retained by
the session even though resumable was disabled. Also note that the default time-out for an
enabled session is 7,200 seconds.
SQL> alter session enable resumable;
Session altered.
SQL> select dbms_resumable.get_timeout from dual;
GET_TIMEOUT
-----------
7200
SQL> exec dbms_resumable.set_timeout (9600);
Search WWH ::




Custom Search