Re: Question on set autotrace on statistics
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 1500 NEXT 1500 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).
Re: Question on set autotrace on statistics
Because you can trace DML, not DDL. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 10:59 AM 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 1500 NEXT 1500 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: Igor Neyman 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).
RE: Question on set autotrace on statistics
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 1500 NEXT 1500 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).
