Oracle 视图 DBA_OPTSTAT_OPERATION_TASKS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_OPTSTAT_OPERATION_TASKS显示数据库内最近被实行的优化绩效管理任务的信息。该视图可以用来显示运行在时间跨度内运行的不同事件,如自动收集绩效统计信息、分析器优化等。该视图可以用来监控优化器操作状态,并根据需要记录或删除这些数据,以及监视优化绩效管理任务的执行情况。
官方英文解释
DBA_OPTSTAT_OPERATION_TASKS
displays the history of tasks that are performed as part of statistics operations (recorded in DBA_OPTSTAT_OPERATIONS
). Each task represents a target object to be processed in the corresponding parent operation.
Column | Datatype | NULL | Description |
---|---|---|---|
|
| Internal identifier for the statistics operation that the task belongs to | |
|
| Name of the object that this task operates on | |
|
| Object number of the target object | |
|
| Type of the target object. Possible values are:
| |
|
| Target size (in number of blocks) when the task started | |
|
| Task start time | |
|
| Task end time | |
|
| Current task status. Possible values are:
| |
|
| Name of the scheduler job that executes this task (for example, when concurrency is on) | |
|
| Estimated cost of the task (measured as elapsed time in seconds). This column is populated only when concurrency is on. | |
|
| For internal use only | |
|
| For internal use only | |
|
| Rank of the task among all target objects for the parent operation | |
|
| For internal use only | |
|
| Notes about the underlying task, such as the failure message for tasks with status |
See Also:
“DBA_OPTSTAT_OPERATIONS”