sqlplus 有这么几个autotrace，disql呢？

sqlplus 有这么几个autotrace：查看详情

disql呢？

其实就是 SET AUTOTRACE TRACE 比较正经（常用）
其他看看、了解下、知道还能这么执行不报错就行吧…

disql的autotrace怎么用？

假定我们的windows服务器已经安装了达梦数据（并且服务已经启动了，用户名密码和端口号为默认）

C:\Users\noSelf\Downloads\1\bin>disql SYSDBA/SYSDBA

服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 20.375(ms)
disql V8
SQL> set autotrace on
SQL> select * from dual a,dual b,dual c;

0    | CSCN2 | SYSDUAL2 as A | SYSINDEXSYSDUAL2
1    | CSCN2 | SYSDUAL2 as B | SYSINDEXSYSDUAL2
2    | CSCN2 | SYSDUAL2 as C | SYSINDEXSYSDUAL2

已用时间: 0.586(毫秒). 执行号:0.
SQL> select * from dual a,dual b;

0    | CSCN2 | SYSDUAL2 as A | SYSINDEXSYSDUAL2
1    | CSCN2 | SYSDUAL2 as B | SYSINDEXSYSDUAL2

已用时间: 0.366(毫秒). 执行号:0.
SQL> set autotrace trace;
SQL>  select * from dual a,dual b,dual c;

行号       DUMMY DUMMY DUMMY
---------- ----- ----- -----
1          X     X     X


1   #NSET2: [1, 1->1, 3]
2     #PRJT2: [1, 1->1, 3]; exp_num(3), is_atom(FALSE)
3       #NEST LOOP INNER JOIN2: [1, 1->1, 3];
4         #NEST LOOP INNER JOIN2: [1, 1->1, 2];
5           #CSCN2: [1, 1->1, 1]; SYSINDEXSYSDUAL2(SYSDUAL2)
6           #CSCN2: [1, 1->1, 1]; SYSINDEXSYSDUAL2(SYSDUAL2)
7         #CSCN2: [1, 1->1, 1]; SYSINDEXSYSDUAL2(SYSDUAL2)

已用时间: 0.600(毫秒). 执行号:8902.
SQL> set autotrace nl
SQL> select * from dual a,dual b,dual c;

0    | NEST LOOP INNER JOIN2 | select * from dual a,dual b,dual c;
1    | NEST LOOP INNER JOIN2 | select * from dual a,dual b,dual c;

已用时间: 0.429(毫秒). 执行号:0.
SQL> set autotrace index
SQL> select * from dual a,dual b,dual c;

0    | CSCN2 | SYSDUAL2 as A | SYSINDEXSYSDUAL2
1    | CSCN2 | SYSDUAL2 as B | SYSINDEXSYSDUAL2
2    | CSCN2 | SYSDUAL2 as C | SYSINDEXSYSDUAL2

已用时间: 0.346(毫秒). 执行号:0.
SQL> set autotrace off;
SQL> select * from dual a,dual b;

行号       DUMMY DUMMY
---------- ----- -----
1          X     X

已用时间: 0.534(毫秒). 执行号:8906.
SQL> exit

C:\Users\noSelf\Downloads\1\bin>