errorstack(手记1学习）

好处：进行错误跟踪和诊断

1.

>alter system set event '984 trace name errorstack forever,level 3'

>conn aiki/aiki;

create table t(a varchar2(8), b number);

insert into t values(a,1);

ERROR at line 1:
ORA-00984: column not allowed here

>alter system set event '984 trace name errorstack off';

2.

OS Pid: 26335 executed alter system set events '984 trace name errorstack forever,level 3'
Tue Aug 14 05:21:19 2012
Errors in file /u01/app/oracle/admin/devdb/udump/devdb1_ora_26516.trc:
ORA-00984: column not allowed here
Tue Aug 14 05:21:19 2012
Trace dumping is performing id=[cdmp_20120814052119]
Tue Aug 14 05:22:12 2012
OS Pid: 26867 executed alter system set events '984 trace name errorstack off'

3.查看trace文件，但通过trace暂未看懂具体含义，下次再更新次；