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

Question on "set autotrace on statistics"

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

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 li

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 >