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(*)
----------
0
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
