Re: autotrace not showing statistics

"peter" <hhh.database_at_gmail.com> wrote in message news:1175245244.131875.13300_at_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.
>

Although your database is 9.2.0.8, it looks as if you are running an earlier version of the SQL*Plus client (pre-9.2.0.5) and logged on as SYS.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html