Oracle 视图 V$QMON_TASKS 官方解释，作用，如何使用详细说明
本站中文解释
V$QMON_TASKS 视图显示Oracle数据库中当前运行和排队的任务。该视图包含了排队/运行的任务的任务ID，任务类型，子任务状态，开始时间，完成时间等列。
使用方法：通过Oracle数据库，用户可以使用以下语法查询V$QMON_TASKS视图：
SELECT *FROM V$QMON_TASKS;
官方英文解释
V$QMON_TASKS displays information and statistics about all queue background tasks in the system, which would be served by queue monitor servers. There is one row per task. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Task name |
|
|
|
Unique task number |
|
|
|
Task type |
|
|
|
Task submit time |
|
|
|
Task ready time |
|
|
|
Time when this task expires |
|
|
|
Last actual start time for the task |
|
|
|
Status of the task |
|
|
|
Name of the QMON server running this task |
|
|
|
Maximum retry count for the task |
|
|
|
Number of runs of the task if repeatable |
|
|
|
Number of failures encountered while running the task |
|
|
|
The ID of the container to which the data pertains. The |
