问题诊断方法.pptxVIP

问题诊断方法第1页/共50页 TopicsHow 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 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 Trace Debug DataHow 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?第2页/共50页 How To Get Level 12 Trace?为什么需要Trace?提取执行与错误信息获取执行程序/SQL获取执行计划与成本信息获取绑定变量值获取等待事件等第3页/共50页 How To Get Level 12 Trace?Gathering 10046 traceSQL_TRACE是Oracle数据库提供的用于进行SQL跟踪的手段，在某种意义上讲，可以说是Oracle最强有力的辅助诊断工具。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 第4页/共50页 How To Get Level 12 Trace?在EBS中启用10046 trace切换到系统管理员职责Navigate : System Administrator Profile= System 在用户层查询 profile option Initialization SQL Statement-CustomUser: User submitting the processProfile: Initialization SQL Statement - Custom编辑User字段，输入下列值并保存 begin fnd_ctl.fnd_sess_ctl(,,TRUE,TRUE,LOG,ALTER SESSION SET EVENTS=||||10046 TRACE NAME CONTEXT FOREVER,LEVEL 12||); end;ALTER SESSION SET TRACEFILE_IDENTIFIER=trace_file max_dump_file_size=unlimited EVENTS=10046 TRACE NAME CONTEXT FOREVER, LEVEL 12第5页/共50页 How To Get Level 12 Trace?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; alter session set events 10046 trace name context forever,level 12;alter session set events 10046 trace name context off;set timed_statistics系统统计信息的粒度，需要设置为true,否则基于时间的统计都没有了第6页/共50页 How To Get Level 1