Which three statements about resumable space allocation are true? (Choose three.)
A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B. A resumable statement is suspended only if an out of space error occurs.
C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D. A resumable statement can only be suspended and resumed once during the execution of the statement.
E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
Answer: ACE您已通过设置RESUMABLE_TIMEOUT参数为一个非零值在您的数据库中启用可恢复的空间分配。
A、即使对数据库启用可恢复的空间分配，你可以为一个单一的会话禁用可恢复的空间分配。
C、当暂停一条可恢复的语句时，包含该语句的交易也被暂停。
E、你可以查询V$SESSION_WAIT动态性能视图以识别会话暂停的语句。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2123698/ ，如需转载，请注明出处，否则将追究法律责任。
