Database Reference
In-Depth Information
space allocation
, and it allows the DBA to fix a problem prior to the database returning an
error message to the user process. Once you've fixed the problem, the database automatically
resumes the suspended operation.
Enabling resumable space allocation is simple: You can set the initialization parameter
RESUMABLE_TIMEOUT
to a value greater than zero, or you can issue the
ALTER SESSION ENABLE
RESUMABLE
statement.
Understanding Resumable Space Allocation
A resumable statement suspends when an object runs out of space, it reaches the maximum
number of extents, or a space quota is exceeded. An object running out of space or reaching
maximum extents applies to tables, indexes, temporary segments, undo segments, large objects
(LOBs), clusters, and table or index partitions. When a resumable statement is suspended, an
error is reported in the alert log and the system issues the resumable session suspended alert,
and if an
AFTER SUSPEND
trigger is in place, it will be executed. When the statement is sus-
pended, the transaction will be suspended and all transaction resources held until rolled back
or the suspend operation is resumed to completion. When the suspend condition is resolved, it
will automatically resume and the associated resumable session suspended alert is cleared; of
course, the original error message logged in the alert log remains.
In a distributed transaction, the remote
RESUMABLE_TIMEOUT
initialization
parameter applies to the remote part of the transaction, and the remote
session resumable setting applies. Also, local resumable settings do not
apply to the remote part of the distributed transactions.
Resumable Space Operations
Specific Data Definition Language (DDL), Import/Export, Data Manipulation Language
(DML), and query statements are candidates for resumable executions:
■
SELECT
statements that run out of sort area temporary space
■
INSERT
,
UPDATE
,
DELETE
, and
INSERT INTO…SELECT
Export/import and SQL*Loader
■
The following DDL statements:
■
CREATE TABLE AS SELECT
CREATE INDEX
ALTER TABLE MOVE PARTITION
ALTER TABLE SPLIT PARTITION
ALTER INDEX REBUILD
ALTER INDEX REBUILD PARTITION
ALTER INDEX SPLIT PARTITION
CREATE MATERIALIZED VIEW
CREATE MATERIALIZED VIEW LOG
Search WWH ::
Custom Search