针对ORA-利用errorstack跟踪

SQL> alter system set events '12899 trace name errorstack level 3';    --开启跟踪

Session altered.

SQL> insert into test1 values('aaaaaaaaaaaaa',1);
insert into test1 values('aaaaaaaaaaaaa',1)
                         *
ERROR at line 1:
ORA-12899: value too large for column "SYS"."TEST1"."NAME" (actual: 13,
maximum: 10)

查看ALERT日志，可以找到trace文件：
Sat Jan 26 14:47:53 2013
OS Pid: 20397 executed alter system set events '12899 trace name errorstack level 3'
Errors in file /oracle/diag/rdbms/xuhm/xuhm/trace/xuhm_ora_20397.trc:
ORA-12899: value too large for column "SYS"."TEST1"."NAME" (actual: 13, maximum: 10)
Sat Jan 26 14:48:04 2013
Dumping diagnostic data in directory=[cdmp_20130126144804], requested by (instance=1, sid=20397), summary=[abnormal process termination].

查看trace:
[oracle@localhost trace]$ vi /oracle/diag/rdbms/xuhm/xuhm/trace/xuhm_ora_20397.trc

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-12899: value too large for column "SYS"."TEST1"."NAME" (actual: 13, maximum: 10)
----- Current SQL Statement for this session (sql_id=dw4yq3vp2wm8v) -----
insert into test1 values('aaaaaaaaaaaaa',1)

----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+36        call     kgdsdst()            000000000 ? 000000000 ?
                                                   7FFF61C23498 ? 000000001 ?
                                                   000000001 ? 000000002 ?
ksedst1()+98         call     skdstdst()           000000000 ? 000000000 ?
                                                   7FFF61C23498 ? 000000001 ?

SQL> alter system set events '12899 trace name errorstack off';     --关闭跟踪

System altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26655292/viewspace-753377/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26655292/viewspace-753377/