autotrace not showing statistics

From: peter <hhh.database_at_gmail.com>
Date: 30 Mar 2007 02:00:44 -0700
Message-ID: <1175245244.131875.13300@l77g2000hsb.googlegroups.com>

SQL> exec dbms_stats.gather_table_stats('SYS', 'PLAN_TABLE', METHOD_OPT=>'FOR ALL COLUMNS'); PL/SQL procedure successfully completed.

SQL> set autotrace traceonly explain statistics SQL> select * from plan_table;

2268 rows selected.

Execution Plan

   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=2268 Bytes=25
          4016)

   1    0   TABLE ACCESS (FULL) OF 'PLAN_TABLE' (Cost=6 Card=2268 Byte
          s=254016)

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)
       2268  rows processed

SQL> SET AUTOTRACE OFF
SQL> SHOW PARAMETER STATISTIC

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

statistics_level                     string      ALL
timed_os_statistics                  integer     5
timed_statistics                     boolean     TRUE

SQL> SHOW PARAMETER TIMED_STATI

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

timed_statistics                     boolean     TRUE

oracle database : 9.2.0.8
OS : Windows XP

Could anyone please let me what can be problem, why I cann't see the statistics here. Received on Fri Mar 30 2007 - 04:00:44 CDT