Databases Reference
In-Depth Information
By querying the
DBA_RESUMABLE
view (
A
), it can be seen that a problem with an
INSERT
statement arose, this problem produced an
ORA-01653
error, the same as the
one reported in the previous log file.
The operator reacts and manually increases the size of the delinquent datafile (
B
),
providing enough space for the process to continue.
Once the problem has been fixed the process continues. As long as there are no
more problems, both the
SUSPEND_TIME
and
ERROR_MSG
columns will display null
values (
C
). As soon as the process finishes the entry, the
DBA_RESUMABLE
view is
cleared (
D
).
This approach happens to be more manageable, but it still requires manual
intervention. During a batch load scheduled during a constrained time frame at
(let's say) three o'clock in the morning, it is better to be peacefully resting in bed,
rather than waiting for your mobile to display an alert because the process has
aborted and the load has to be launched again. In this case a special system trigger is
coded, the
AFTER
SUSPEND
trigger.
The resumable feature triggers when an outstanding associated event is about to
abort the process, issuing a
SUSPEND
event to the database. An
AFTER
SUSPEND
trigger
fires and it executes the routine the DBA has programmed.
Search WWH ::
Custom Search