Oracle 视图 DBA_RESUMABLE 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_RESUMABLE是Oracle自己定义的视图，用来显示当前用户可以暂停空间释放工作的信息。它会显示可挂起的工作的ID、SESSION_ID、用户名、完成时间、暂停/恢复状态（paused/resumable）和错误，用以查询它们的健康状态。
使用Oracle视图DBA_RESUMABLE来检查哪些工作可以挂起，可以使用以下内容体的查询：
SELECT username, sid, serial#, command, error_msg, paused from dba_resumable;
官方英文解释
DBA_RESUMABLE displays all resumable statements executed in the system.
Related View
USER_RESUMABLE displays the resumable statements executed by the current user. This view does not display the USER_ID column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
User ID Number of the Resumable Statement Owner |
|
|
|
|
Session Identifier of the Resumable Statement |
|
|
|
|
Instance Number of the Resumable Statement |
|
|
|
|
Instance Number on which the Parallel Coordinator is Running |
|
|
|
|
Session Identifier of the Parallel Coordinator |
|
|
|
|
Status of the resumable statement:
|
|
|
|
|
Timeout of the resumable statement |
|
|
|
|
Start time of the resumable statement |
|
|
|
|
Last time the resumable statement was suspended (initialized to NULL) |
|
|
|
|
Last time the suspended resumable statement was resumed (initialized to NULL) |
|
|
|
|
Name given in the resumable clause of the resumable statement |
|
|
|
|
Resumable statement, selected from the |
|
|
|
|
Error code of the last correctable error. When |
|
|
|
|
First parameter for the error message (NULL if no error) |
|
|
|
|
Second parameter for the error message (NULL if no error) |
|
|
|
|
Third parameter for the error message (NULL if no error) |
|
|
|
|
Forth parameter for the error message (NULL if no error) |
|
|
|
|
Fifth parameter for the error message (NULL if no error) |
|
|
|
|
Error message corresponding to |
See Also:
“USER_RESUMABLE”
