查看哪些索引没有被使用

<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.