SET_SESSION_TIMEOUT Procedure

This procedure sets the timeout of resumable space allocations for a session with session_id. The timeout is returned in seconds. The new timeout setting applies to the session immediately. If session_id does not exist, no operation occurs.

Syntax

DBMS_RESUMABLE.SET_SESSION_TIMEOUT (

session_id  IN NUMBER,
timeout IN NUMBER);

Parameters

Table 55-4 shows the parameters for the SET_SESSION_TIMEOUT procedure.

Table 55-4 SET_SESSION_TIMEOUT Procedure Parameters

Parameter	Description
session_id	The session identifier of the resumable space allocation.
timeout	The timeout of the resumable space allocation.