Oracle-L: RE: Question on "set autotrace on statistics"

From: <John.Hallas_at_vodafone.co.uk>
Date: Wed, 05 Feb 2003 08:49:02 -0800
Message-ID: <F001.0054461D.20030205084902@fatcity.com>

SET AUTOTRACE only reports on DML (select, update,insert , delete) statements.
The commands you ran were DDL commands
If you notice at the end you did a count of the plan_table and that reported statistics

John

-----Original Message-----
Sent: 05 February 2003 15:59
To: Multiple recipients of list ORACLE-L

Hi:

I am trying to understand why sqlplus did not display stats when I run "analyze table ..." and "create index ..."?

TIA. Guang

SQL> set autotrace on statistics
SQL> analyze table gene_upr compute statistics;

Table analyzed.

SQL> desc gene_upr;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 ID                                                 NUMBER
 NAME                                               VARCHAR2(128)
 NAME_UPR                                           VARCHAR2(128)
 SPECIESID                                          NUMBER

SQL> CREATE index gene_upr_id_index
  2 ON gene_upr(id)
  3 TABLESPACE INDEXES nologging
  4 STORAGE (INITIAL 15000000 NEXT 15000000 pctincrease 0);

Index created.

SQL> select count(*) from plan_table;

COUNT(*)

Statistics

          0  recursive calls
          4  db block gets
          1  consistent gets
          0  physical reads
          0  redo size
        187  bytes sent via SQL*Net to client
        311  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: gmei
INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <John.Hallas_at_vodafone.co.uk
INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------