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).