【原创】autotrace中statistics为0的问题的解决

环境：AIX 5.2

数据库版本：10.2.0.2

在对数据库进行autotrace的时候，发现所有SQL的结果中statistics除了行数外都是0

fgos@FGOSDB>set autotrace traceonly statistics

fgos@FGOSDB>select leg from fgos.VIEW_LEG_TIMESTAMP where PLEG_AP_THR_ARR='DAX' or PLEG_AP_THR_ARR='KWE';

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
          0  bytes sent via SQL*Net to client
          0  bytes received via SQL*Net from client
          0  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
         16  rows processed

在网上查找，说可能是因为使用sys用户进行autotrace造成的，但是我使用的并非sys用户

最后尝试重建plan_table后问题解决

fgos@FGOSDB>@?/rdbms/admin/utlxplan.sql
create table PLAN_TABLE (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object

fgos@FGOSDB>drop table plan_table;

Table dropped.

fgos@FGOSDB>@?/rdbms/admin/utlxplan.sql

Table created.

fgos@FGOSDB>select leg from fgos.VIEW_LEG_TIMESTAMP where PLEG_AP_THR_ARR='DAX' or PLEG_AP_THR_ARR='KWE';

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
         20  consistent gets
          0  physical reads
          0  redo size
      11162  bytes sent via SQL*Net to client
        479  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
         16  rows processed

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/498744/viewspace-264991/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/498744/viewspace-264991/