Apress.Cost.Based.Oracle.Fundamentals. 看中文翻译版看的很吃力. 当初不知10053事件,看完该书花费了很长的时间!

 10053事件

1 创建测试表 create table zengmuansha_temp01 as select * from dba_objects ;

2 在PL/SQL工具的COMMAND窗口 或者SQLPLUS

3 获得会话id:SELECTSYS_CONTEXT ('USERENV', 'SID') sid FROM DUAL;

4 设置跟踪文件标识: altersession set tracefile_identifier='kk_flag';

5 alter session set events '10053 trace name context forever, level 1';

6 declare

typetype_owner istableofzengfankun_temp01.owner%typeindexbybinary_integer;

typetype_object_name istableofzengfankun_temp01.object_name%typeindexbybinary_integer;

typetype_object_id istableofzengfankun_temp01.object_id%typeindexbybinary_integer;

typetype_object_type istableofzengfankun_temp01.object_type%typeindexbybinary_integer;

typetype_last_ddl_time istableofzengfankun_temp01.last_ddl_time%typeindexby