Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: autotrace not showing statistics
On Mar 30, 5:04 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk>
wrote:
> "peter" <hhh.datab..._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 Lewishttp://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentalshttp://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html- Hide quoted text -
>
> - Show quoted text -
Thank a lot.
That was the solution I was looking for.... I understand my mistake.
So thanks again.
Received on Sun Apr 01 2007 - 22:42:33 CDT
![]() |
![]() |