54 You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT par

最新推荐文章于 2022-02-20 18:06:40 发布

EVISWANG

最新推荐文章于 2022-02-20 18:06:40 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： OCP 053

本文链接：https://blog.youkuaiyun.com/EVISWANG/article/details/50052843

54
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT
parameter set to a nonzero value.
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.