AFTER SUSPEND trigger effects - Oracle Schema

Q.  Which effects will a trigger have in the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session?
- Published on 04 Aug 15

a. If an undo segment has not reached its space limit, then a message is sent to the DBA and the statement is aborted
b. If any other recoverable error has occurred, the timeout interval is reset to 10 hours
c. Both A & B
d. None of the above

ANSWER: None of the above
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - A system wide AFTER SUSPEND trigger is created and registered as user SYS at the database level.

    - Whenever a resumable statement is suspended in any session, this trigger can have either of two effects:

    1. If an undo segment has reached its space limit, then a message is sent to the DBA and the statement is aborted.

    2. If any other recoverable error has occurred, the timeout interval is reset to 8 hours.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)