Re: autotrace not showing statistics

On Mar 30, 11:00 am, "peter" <hhh.datab...@xxxxxxxxx> wrote:
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.

Apparently you need glasses. I see

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


Look at the first line, carefully. What does it read?

--
Sybrand Bakker
Senior Oracle DBA

.

Relevant Pages