You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?
When the initialization parameter resumable_timeout is set, statements that encounter space allocation failures will be suspended to allow time for corrective action. During the timeout period, if the issue is resolved, the statement can resume execution; if not, it will report an error when the timeout period expires. Additionally, to enable the resumable functionality, the statement alter session enable resumable must be issued in the session before execution. This ensures that the suspension and resumption feature is active.
The correct answer is CD, it can suspended multiple times, not once
i agree C D
Setting the timeout for resumable space allocation doesn't require individual session to enable that feature. That's why it is set in instance level.
Answer CD