Database Reference
In-Depth Information
PL/SQL procedure successfully completed.
SQL> select dbms_resumable.get_timeout from dual;
GET_TIMEOUT
-----------
9600
SQL> alter session disable resumable;
Session altered.
SQL> select dbms_resumable.get_timeout from dual;
GET_TIMEOUT
-----------
9600
SQL> alter session enable resumable timeout 7200;
Session altered.
SQL> select dbms_resumable.get_timeout from dual;
GET_TIMEOUT
-----------
7200
Triggered Events to Respond to Suspends
Oracle has created the AFTER SUSPEND trigger to help you resolve suspend conditions program-
matically. By registering an AFTER SUSPEND trigger on the database as user SYS using the ON
DATABASE clause, you can take action regardless of who owns the resumable operation. Here's
an example:
SQL> CREATE OR REPLACE TRIGGER resumable_default_timeout
AFTER SUSPEND
ON DATABASE
BEGIN
DBMS_RESUMABLE.SET_TIMEOUT(14400);
END;
/
Search WWH ::




Custom Search