Oracle教程 2023-02-24

Oracle 视图 V$ADVISOR_PROGRESS 官方解释，作用，如何使用详细说明

Oracle视图V$ADVISOR_PROGRESS报告Advisor程序运行的进度。

用途：

V$ADVISOR_PROGRESS可以用来监控Advisor的运行进度，以及查看它的执行结果。这种视图还可以捕获Advisor程序的调用结果，因此，我们可以使用它来检查某一个任务项是否已经完成执行。

使用方法：

V$ADVISOR_PROGRESS可以通过使用SQL查询去查看。示例：

SELECT adp.task_name, adp.status, adp.start_time, adp.end_time FROM v$advisor_progress adp;

V$ADVISOR_PROGRESS displays information about the progress of advisor execution.

Column	Datatype	Description
`SID`	`NUMBER`	Session ID
`SERIAL#`	`NUMBER`	Session serial number
`USERNAME`	`VARCHAR2(128)`	Oracle user name
`OPNAME`	`VARCHAR2(64)`	Operation name
`ADVISOR_NAME`	`VARCHAR2(64)`	Advisor name
`TASK_ID`	`NUMBER`	Task ID
`TARGET_DESC`	`VARCHAR2(32)`	Description of the target of the advisor
`SOFAR`	`NUMBER`	Amount of work done so far
`TOTALWORK`	`NUMBER`	Total work to be done
`UNITS`	`VARCHAR2(32)`	Units that the work is measured in
`BENEFIT_SOFAR`	`NUMBER`	Benefit obtained so far
`BENEFIT_MAX`	`NUMBER`	Estimate of maximum benefit that could be obtained
`FINDINGS`	`NUMBER`	Number of findings so far
`RECOMMENDATIONS`	`NUMBER`	Number of recommendations so far
`TIME_REMAINING`	`NUMBER`	Estimate of time remaining for the completion of the task (in seconds)
`START_TIME`	`DATE`	Start time of the task
`LAST_UPDATE_TIME`	`DATE`	Last time progress was posted
`ELAPSED_SECONDS`	`NUMBER`	Elapsed time so far
`ADVISOR_METRIC1`	`NUMBER`	Value of the advisor-specific metric
`METRIC1_DESC`	`VARCHAR2(64)`	Description of the advisor-specific metric
`EXECUTION_TYPE`	`VARCHAR2(64)`	Type of the last execution. This information is optional for single-execution tasks.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：