<pre name="code" class="sql">select distinct object_name
from (select object_name
from dba_hist_sql_plan
where object_owner = 'DWF'
union all
select object_name from v$sql_plan where object_owner = 'DWF')
where object_name = 'SYS_C0036662'
DBA_HIST_SQL_PLAN displays the execution plan information for each child cursor in the workload repository. This view captures information from V$SQL_PLAN
and is used with the DBA_HIST_SQLSTAT view.
显示了每个子游标的执行计划信息在workload repository,这个视图捕捉了从V$SQL_PLAN 被 DBA_HIST_SQLSTAT使用
V$SQL_PLAN contains the execution plan information for each child cursor loaded in the library cache.