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: 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).
- = = = = = = = = = = = = = = = = = = =
致
礼！
chao_ping
chao_ping_at_vip.163.com
2003-02-06
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
INET: chao_ping_at_vip.163.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 Thu Feb 06 2003 - 20:08:42 CST
