55
DBMS_RESUMABLE

With DBMS_RESUMABLE, you can suspend large operations that run out of space or reach space limits after executing for a long time, fix the problem, and make the statement resume execution. Thus, you can write applications without worrying about running into space-related errors.

When a statement is suspended, the act of suspending should be logged in the alert log. You should also register a procedure to be executed when the statement is suspended. Using a view, you can monitor the progress of the statement and indicate whether the statement is currently executing or suspended.

Suspending a statement automatically results in suspending the transaction. Thus all transactional resources are held during a statement suspend and resume. When the error condition disappears, the suspended statement automatically resumes execution. A resumable space allocation can be suspended and resumed multiple times during execution.

A suspension timeout interval is associated with resumable space allocations. A resumable space allocation that is suspended for the timeout interval (the default is two hours) wakes up and returns an exception to the user. A suspended statement may be forced to throw an exception using the DMBS_RESUMABLE.ABORT() procedure.

This chapter discusses the following topics:

• Summary of DBMS_RESUMABLE Subprograms

Summary of DBMS_RESUMABLE Subprograms

Table 55-1 DBMS_RESUMABLE Subprograms

Subprogram	Description
"ABORT Procedure"	Aborts a suspended resumable space allocation.
"GET_SESSION_TIMEOUT Function"	Returns the current timeout value of the resumable space allocations for a session with session_id.
"SET_SESSION_TIMEOUT Procedure"	Sets the timeout of resumable space allocations for a session with session_id.
"GET_TIMEOUT Function"	Returns the current timeout value of resumable space allocations for the current session.
"SET_TIMEOUT Procedure"	Sets the timeout of resumable space allocations for the current session.
"SPACE_ERROR_INFO Function"	Looks for space-related errors in the error stack. If it cannot find a space-related error, it will return FALSE.