多多色-多人伦交性欧美在线观看-多人伦精品一区二区三区视频-多色视频-免费黄色视屏网站-免费黄色在线

國內最全IT社區平臺 聯系我們 | 收藏本站
阿里云優惠2
您當前位置:首頁 > 數據庫 > 數據庫應用 > Oracle EBS Forms查看trace file

Oracle EBS Forms查看trace file

來源:程序員人生   發布時間:2016-08-10 13:49:41 閱讀次數:4645次

Introduction:

Some times we need to diagnose the issue or error coming in forms. For such situation we need to get more information about the issue we are facing in forms. One of the best way to get such information is using tracing.

Many types of tracing are available in forms. We will discuss couple of methods for enabling the tracing and see how that can help us in diagnosing the issue.

Enabling SQL Tracing

First we see how to enable a normal SQL tracing. In my case I have a forms where I am entering few values and then saving the form. This will have some insert and updates command in the backend which will get executed when we save the form. SQL tracing is used to track those DML queries to debug the issue. When we open the form we can see on the menu option

Help -> Diagnostic -> Trace ->

Here we have many options available (default is ‘No Trace’). We can enable tracing by selecing on of the options from here.  ‘Regular Trace’ gives the least information and ‘Trace with Binds and Waits’ (level 12) gives maximum information. Be careful while enabling SQL trace with wait and binds as this will make the trace file huge.

Also we can start the tracing in the middle of forms sessions also. Example in my case I wanted to check the last insert/update DML statements that gets fired when we save the form. So after we fill all the values in the fields, we can start the tracing so that the initial select statement does not come in trace file.

When we enable the trace it will give the trace file location (This location will be the location of USER_DUMP_DESTINATION parameter of database).

After you save the form you can stop tracing by selecting ‘No Trace’ again from Help -> Diagnostic -> Trace -> No Trace

Use tkprof to covert trace file in readable format.

-bash⑵.05b$ tkprof md9ys210_ora_20412_MFG.trc
output = trace_sql.txt

TKPROF: Release 10.2.0.4.0 – Production on Mon Jul 28 23:54:31 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

-bash⑵.05b$

Enabling Forms Tracing

Another way for debugging is to enable tracing at forms level for a particular user. This method is also explained in metalink note ID 373548.1. By default, it will trace errors only. To utilize the full flexibility of Forms Trace, the record=forms parameter must be used in conjunction with the tracegroup parameter.

Applications Development has created several recommended levels of tracing, which are predefined in the file $ORA_CONFIG_HOME/10.1.2/forms/server/ftrace.cfg

  • light (0⑺1,192): Records user actions, error messages and form service events.
  • medium (0⑼7,192,194,195): Includes events in the light tracegroup also captures built-in and user-exit events.
  • full (0⑼8,100⑴99): Captures all information that is currently available through Forms Tracing.
  • dbsql (32,64,98,100,101,136,137,192): All events related to the database and forms interaction with it
  • network (64,32,128,129,131,130,132,133,134,192): All events related to communications between client tier and Forms server.

In my case I am enabling the tracing for SQLs.

Please follow below steps to enable form level tracing.

  1. Sign on to Oracle Applications as a user with the System Administrator responsibility.
  2. Select the System Administrator responsibility.
  3. Select the Profile -> System function (this will launch Forms).
  4. Search for the Applications user and the profile option Forms Runtime Parameters.
  5. Add the required parameters, using the syntax: record=forms tracegroup=dbsql
    You can use any other value also for tracegroup depending on your requirement. Examples:

    record=forms tracegroup=medium

    Note the space between the parameter/value pairs.

  6. Commit the changes and log out of Applications.
  7. Restart the Forms OC4J group using either adformsctl.sh (servlet) oradformsrvctl.sh (socket).
  8. Log in to Applications as the user whose Forms Runtime Parameters profile option was amended.

Before doing this, metalink note ID also mention to append “record=forms” at the end ofICX: Forms Launcher profile for that user. Example

http://rws60048rems.us.oracle.com:8058/forms/frmservlet?record=forms

But when I tried that I got following error.

FRM⑼0926: Duplicate Parameter on command line.

So I removed record=forms and I was able to generate the trace files without any issue. This may be some issue with my instance.

Once you set the profile “Forms Runtime Parameters”, bounce the forms and try to accecss forms, it will generate a trace file at the location defined by FORMS_TRACE_DIR. After you finish the navigation in form and exit, your trace file will get created FORMS_TRACE_DIR location.

This file will be in binary format and cannot be read. You need to convert this into .txt or .html format using following command

java -cp $ORACLE_HOME/forms/java/frmxlate.jar oracle.forms.diagnostics.Xlatedatafile=forms_8842.trc outputfile=forms_trace1.html outputclass=WriteOutHTML

Here,

datafile=forms_8842.trc is the name of trace file that got created due to activities on forms.

outputfile=forms_trace1.html is the name of output file that will get created. You can use html or .txt

outputclass=WriteOutHTML parameter decides if the output file should be HTML or TXT. If you use just WriteOut then output file will be TXT. If you use WriteOutHTMLthen output file will be HTML.

The output HTML file will look like this.

Hope this helps !!

References:

Metalink note ID 373548.1

生活不易,碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
程序員人生
------分隔線----------------------------
分享到:
------分隔線----------------------------
關閉
程序員人生
主站蜘蛛池模板: 欧美人与z0z0xxxx | 黑人猛操| 久久伊人成人网 | 日韩亚洲国产欧美精品 | 中国老头gay高清xxxx | 国产欧美亚洲三区久在线观看 | 欧美一级毛片高清毛片 | 亚洲色图欧美色 | 德国女人一级毛片免费 | 在线 成人| 午夜三级成人三级 | 2022精品天堂在线视频 | 日韩爱爱小视频 | 清纯唯美亚洲综合五月天 | 91美女啪啪 | www.欧美xxx | 成人国产欧美精品一区二区 | 国产亚洲欧美日韩在线看片 | 成人免费的性色视频 | 亚洲欧洲国产成人综合一本 | 中国free性护士xxxxhd | 亚洲图片小说网 | japanese日本护士xx在线 | 亚洲网站在线观看 | 日本特黄高清免费大片爽 | 国内精品视频 在线播放 | 久久最新视频 | 亚洲噜噜噜噜噜影院在线播放 | 国产午夜视频在线观看第四页 | 国产精品成人一区二区1 | 秋霞理论一级在线观看手机版 | 亚洲最新在线视频 | 欧美一级特黄啪啪片免费看 | 性欧美日韩 | 色性欧美| 亚洲永久免费网站 | 成人一级网站 | 美女毛片视频 | 香蕉高清免费永久在线视频 | 欧美亚洲综合在线 | 欧美成人性色xxxx视频 |