gmei,���ã�
hi, you can look into v$mystat or v$sesstat to get those status value.
Good luck.
======= 2003-02-05 07:59:00 �������������=======
>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).
= = = = = = = = = = = = = = = = = = = =
������������������
��
����������������chao_ping
����������������[EMAIL PROTECTED]
��������������������2003-02-06
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
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).
