How to trace a concurrent program in EBS

Source: Internet
Author: User

In thislink, we had mentioned abouttracing a concurrent program, but the drawback of this method is it doesnt yield information about the BIND variable values. so in this post we will talk about it. scenarioX submitted a concurrent request and its running for a long time and never completes. X approached you to see what is the problem with the concurrent request. steps1. Inform. X to logout from his ERP session.2. Login as sysadmin user3. System Administrator-> Profile (System) 4. values: User = X, Profile = Initialization SQL Statement-Custom (you can also mention Initialization % Custom) 5. under user field enter the followingbegin fnd_ctl.fnd_sess_ctl (",", 'true', 'true', 'log', 'alter session set events = "10046 trace name context forever, LEVEL 12 "TRACEFILE_IDENTIFIER =" [ANY_IDENTIFIER] "'); end; [ANY_IDENTIFIER] = Any value to identify the trace file. LEVEL 12-Both Binds and WaitsLEVEL 8-Only WAITSLEVEL 4-Only BIND VariablesAll abve levels will include the SQL statements being executed and not only the binds and waits.6. If tracing had been enabled at the concurrent program level as mentioned in this link, please disable it by removing the check box. [IMPORTANT]. if you have trace enabled for the concurrent program, then it will take precedence for the profile option.7. Kill/cancel the long running concurrent request (if its still running) 8. request X to login to ERP and instruct X to submit the concurrent request again and logout. nothing else. this will ensure we capture the trace information specific to the concurrent request and not for other actions. at this stage, you will find a trace file generated at $ ORACLE_HOME/admin/SID_Hostname/udump with [ANY_IDENTIFIER] as part of it. inside the trace file you will be able to see information about the bind variable values being passed to and used by the concurrent program. eg: Bind #0 oacdty = 12 mxl = 07 (07) mxlc = 00 mal = 00 scl = 00 pre = 00 oacflg = 13 fl2 = 206001 frm = 00 csi = 00 siz = 8 ff = 0 kxsbbbfp = 9fffffffbf2e88d8 bln = 07 avl = 07 flg = 09 value = "[bind variable value]" Bind #1 oacdty = 12 mxl = 07 (07) mxlc = 00 mal = 00 scl = 00 pre = 00 oacflg = 13 fl2 = 206001 frm = 00 csi = 00 siz = 8 ff = 0 kxsbbbfp = 9fffffffbf2e88f8 bln = 07 avl = 07 flg = 09 value = "[bind variable value]" Note: make sure you remove the profile option value for X after the job is done, else every action of X will generate a trace file in udump directory.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.