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

From: gmei <gmei_at_incyte.com>
Date: Wed, 05 Feb 2003 07:59:04 -0800
Message-ID: <F001.0054453D.20030205075904@fatcity.com>

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). Received on Wed Feb 05 2003 - 09:59:04 CST