How To Get Level 12 Trace?
在EBS中启用10046 trace
• 切换到<系统管理员>职责
• Navigate : System Administrator > Profile=> System • 在用户层查询 profile option 'Initialization SQL Statement-Custom'
end;
ALTER SESSION SET TRACEFILE_IDENTIFIER='trace_file' max_dump_file_size=unlimited EVENTS='10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'
How To Get Level 12 Trace?
• alter session set events '10046 trace name context forever,level 12';
• alter session set events '10046 trace name context off';
• set timed_statistics系统统计信息的粒度， 需要设置为true,否则基于时间的统计都没有 了
• 10046事件是Oracle提供的内部事件，是对SQL_TRACE的增强 （包含绑定值 与等待事务事件)
• 10046事件可以设置以下四个级别: • 1 - 启用标准的SQL_TRACE功能,等价于sql_trace • 4 - Level 1 加上绑定值(bind values) • 8 - Level 1 + 等待事件跟踪 • 12 - Level 1 + Level 4 + Level 8
How To Get Level 12 Trace?
为什么需要Trace?
• 提取执行与错误信息 • 获取执行程序/SQL • 获取执行计划与成本信息 • 获取绑定变量值 • 获取等待事件等
How To Get Level 12 Trace?
Gathering 10046 trace
• SQL_TRACE是Oracle数据库提供的用于进行SQL跟踪的手段， 在某种意义上讲，可以说是Oracle最强有力的辅助诊断工具。
• User: User submitting the process
• Profile: Initialization SQL Statement - Custom • 编辑User字段，输入下列值并sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET EVENTS='||''''||'10046 TRACE NAME CONTEXT FOREVER,LEVEL 12'||'''');
Session Tracing
• alter session set tracefile_identifier='10046';
• alter session set timed_statistics = true;
• alter session set statistics_level=all;
• alter session set max_dump_file_size = unlimited;
Trace Debug Data • How to Generate Receiving Transaction Debug Statements in 11.5.10
and R12? • How To Debug WIP? • How to get Debug Information for Inventory Material Transaction?
like 'user_dump_dest'
How To Get Level 12 Trace?
What to look for in the trace?
R11.5? • How To Store FA Debug Messages In A File? • How to Get a Debug in Receivables in 11.5.10? • How to run a Payables Concurrent Program in Debug Mode? • How to generate a debug file in OM? • How to Generate and Return the PO Document Approval Manager
• select sid,serial# from v$session where sid=(select distinct sid from v$mystat);
How To Get Level 12 Trace?
• SQL Trace path
• show parameter user_dump_dest • select * from v$parameter where name
EBS问题诊断常用方法
--Oracle SSC --Andrew Du
Topics
• How To Get Level 12 Trace • How To Get Trace File For Concurrent Programs? • How to get Forms Level Trace and FRD? • How To Get FND Debug? • How To Run Selected General Ledger Programs In Debug Mode in
How To Get Level 12 Trace?
Trace other Session
• Open Trace
• exec sys.dbms_system.set_ev(<sid>, <serial#>, 10046, 12, '');
• Close Trace
• exec sys.dbms_system.set_ev(<sid>, <serial#>, 10046, 0, '');