Oracle教程 2023-04-05

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

Oracle视图DBA_HIST_PLAN_OPTION_NAME被用来显示在AWR(自动工作负载重放）报表中诊断当前的操作选项和优化标记。它包含每个操作优化的详细说明和操作的指令代码的参数。该表在报表中以COE ID的形式显示其优化策略，如允许索引使用，驱动表扫描等。

使用DBA_HIST_PLAN_OPTION_NAME视图，可以使用以下查询来检索对应于不同优化策略的参数值:

SELECT option_name,option_value,comments FROM DBA_HIST_PLAN_OPTION_NAME where plan_id=&plan_id and option_name=’&option_name’;

这里，plan_id是AWR报表提供的每个操作的ID，option_name 可以是一个有效的优化选项（即ALL_PLAN_OPTIONS 包含的选项）。

DBA_HIST_PLAN_OPTION_NAME视图提供基本的信息，从而帮助DBA完成优化和性能诊断。

DBA_HIST_PLAN_OPTION_NAME displays historical information about SQL plan option names.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database identifier
`OPTION_ID`	`NUMBER`	`NOT NULL`	Plan option identifier
`OPTION_NAME`	`VARCHAR2(64)`		Plan option name. This value also appears in the `SQL_PLAN_OPTIONS` column of the `DBA_HIST_ACTIVE_SESS_HISTORY` view.
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. 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

分享到：