Forgot your password?    
+ Reply to Thread
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Generate an FRD (Forms Runtime Diagnostics) Trace for any Form in Oracle Applications

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128

    Generate an FRD (Forms Runtime Diagnostics) Trace for any Form in Oracle Applications

    Generating a Forms FRD Trace

    Purpose :
    FRD is a runtime event-based logging system intended to aid in the debugging of Forms applications. FRD is enabled at runtime on a user by user basis. FRD generates extensive output useful for analysis and debugging, and it is therefore recommended FRD be utilized as a logging mechanism only when specific issues are encountered.


    Concept :
    When starting a Forms-based session in Applications two parameters config=debug and record=all which make it possible to perform Forms Runtime Diagnostics (FRD.)

    The Contents of an FRD Log File
    The following data is typically collected in an FRD trace file:
    - Trigger firing: includes name and hierarchical location.
    - Built-in Execution: includes name and IN and OUT parameter types and values.
    - Messages: includes message numbers and text.
    - The opening of forms executables (.fmx) and menu executables (.mmx)
    - Unhandled exceptions: includes error message if available, otherwise only
    error numbers.
    - All external user events via normal runtime (RT) recording mechanism

    Tracing in 11i

    Generate FRD for any Form(Trace Form Session)
    ==================================
    As before, the Forms server process must have permissions to create the file, or no log file will be written. File permissions are those of the Unix/Windows user responsible for starting the Forms server.
    Create a Forms Runtime Diagnostics (FRD) Tracefile

    A:- Via Profile Option "Forms Runtime Parameters"

    1:- Log into applications with the "System Administrators" Responsibility
    2:- Choose Profile>>System
    3:- In the "Find System Profile Values" window tick the USER field and add the username of the user you wish to trace
    4:- Query the profile "Forms Runtime Parameters"
    5:- Set it to
    record=collect log=<USERNAME>.log
    6:- Log out of the application
    7:- Log in as the user chosen at step 3
    8:- Replicate the problem
    9:- See the "Retrieving the Logfile" steps below to find the logfile location

    B:- Via Profile Option "ICX: Forms Launcher"

    If profile 'Forms Runtime Parameters' profile does not exist then the 'ICX: Forms Launcher" Profile should be used
    1:- Log into applications with the "System Administrators" Responsibility
    2:- Choose Profile>>System
    3:- In the "Find System Profile Values" window tick the USER field and add the username of the user you wish to trace
    4:- Query the profile "ICX: Forms Launcher"
    5:- Copy the SITE level value and add the parameters
    ?&record=collect&log=<USERNAME>.log
    So the USER level value for the "ICX: Forms launcher" profile now looks like:

    a) Example URL on Unix with FRD trace enabled:
    http://<HOSTNAME>.<DOMAIN>:<PORT>/dev60cgi/f60cgi?&record=collect&log=<USERNAME>.log
    b) Example URL on Windows platforms with FRD trace enabled
    http://<HOSTNAME>.<DOMAIN>:<PORT>/dev60cgi/ifcgi60.exe?record=collect&log=<USERNAME>.log
    6:- Log out of the application
    7:- Log in as the user chosen at step 3
    8:- Replicate the problem
    9:- Locate the file in the directory as specified in the URL.

    C:- Via Direct Forms Access URL Change

    1:- Append the following text to the direct login (dev60cgi/f60cgi) URL:
    ?record=all&log=<USERNAME>.log
    a) Example URL on Unix with FRD trace enabled:
    http://<HOSTNAME>.<DOMAIN>:<PORT>/dev60cgi/f60cgi?record=collect&log=/tmp/<USERNAME>.log
    b) Example URL on Windows platforms with FRD trace enabled
    http://<HOSTNAME>.<DOMAIN>:<PORT>/dev60cgi/ifcgi60.exe?record=collect&log=C:\Windows\Temp\<US ERNAME>.log
    2:- Replicate the problem
    3:- Upload the logfile defined in the "log=" section of the URL

    NOTE:- Direct Login using dev60cgi/f60cgi is not longer supported.


    Tracing in R12

    1. Set the user value for profile option 'ICX: Forms Launcher' to be
    'http://hostname.domainort/forms/frmservice?record=forms'

    2. By default, this will enable tracing for errors only. As an optional step, you can enable different trace options (e.g. user actions, user-exit events, dbsql events, network events) by setting a trace group in file $ORA_CONFIG_HOME/10.1.2/forms/server/ftrace.cfg

    3. Login to the Personal Home Page, navigate to the form and perform the steps that you wish to trace.

    4. Locate the file in the directory set by variable FORMS_TRACE_DIR. Note: by default, this directory is named forms_<pid>.trc, where <pid> is the process identifier.
    Last edited by Hemant; 01-10-2012 at 08:15 PM.
    Regards,
    -Amit

  2. #2
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    how to trace a concurrent programs for a specific ERP user?

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    1-First get the ERP user login id .
    2- Pull up the SYSTEM profile - make sure in the find screen to select the user & add the user, and add the profile value, in one line, at the profile option value called, ‘Initialization SQL Statement - Custom’, you can put this in your find as well...
    3- Now you need to add the value under the user filed, below the user name, copy this in notepad in one line and paste it. You can change the identifier and the dump file size as well. NOTE IF YOU MAKE A MISTAKE USER WILL NOT BE ABLE TO LOGIN.

    10046 EVENT levels:
    1 - Enable standard SQL_TRACE functionality (Default)
    4 - As Level 1 PLUS trace bind values
    8 - As Level 1 PLUS trace waits
    This is especially useful for spotting latch wait etc.
    but can also be used to spot full table scans and index scans.
    12 - As Level 1 PLUS both trace bind values and waits

    1, 4, 8, 12
    BEGIN FND_CTL.FND_SESS_CTL('','','','','','ALTER SESSION SET EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 1 '||''''); END;
    BEGIN FND_CTL.FND_SESS_CTL('','','','','','ALTER SESSION SET EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 4 '||''''); END;
    BEGIN FND_CTL.FND_SESS_CTL('','','','','','ALTER SESSION SET EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 8 '||''''); END;
    BEGIN FND_CTL.FND_SESS_CTL('','','','','','ALTER SESSION SET EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 '||''''); END;

    You can use either one.

    Also check note : 296559.1

    Regards
    See if it helps

    Regards

  4. #4
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    How do find the concurrent users in forms, concurrent manager

  5. #5
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    If all the users are reporting that is the application is slow, what would be you plan of action? How will you identify the sessions using resources?

    bmy idea ans:i use top command and will find out the top 10 sql statments which are consuming resources?but how can i find the usernames who are using running those sql statements? using top command we can get the pid..so do we need to dig into v$session and findout the users who are using resources? kindly tell me the approach..

    tnx,
    sai.

  6. #6
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    how can we change guest user id and password?we cant change with FNDCPASS?then how can we change?

  7. #7
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    Like if a concurrent request is running for longtime?how can we check the previous execution of similar program? like whats the approach?

  8. #8
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    i use top command and will find out the top 10 sql statments

    So you are saying that you will find top 10 sql statement from top command. If yes plz provide me the details.

    Regards

  9. #9
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    how to know the control file size?..datafile and redolog file sizes?

  10. #10
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    how to know that much of sorting is happening in the database.?and which user is performing much of sorting?sorting first uses pga?and later temporarory tablespace?give me steps

    tnx

+ Reply to Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. IT Resource , Object Form and Process Form in OIM 11g
    By Hemant in forum Oracle Fusion Middleware 11G - OIM , OAM , ODS , Weblogic , Webgate ..
    Replies: 0
    Last Post: 08-25-2012, 02:42 AM
  2. Replies: 0
    Last Post: 01-02-2012, 12:46 AM
  3. Running RDA Diagnostics on E-Business R12
    By Amit in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 11-30-2011, 07:33 PM
  4. Oracle Applications 11i Forms from Socket to Servlet or vice versa without autoconfig
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-30-2011, 01:20 AM
  5. Oracle Applications R12 Changing Forms from Servlet to Socket and vice versa
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-29-2011, 10:52 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics