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