• About Me
  • Disclaimer
  • Now it’s time to change my Oracle ACE to Oracle ACE Director.

Oadba's Blog

~ The Infinite Reference for Oracle Apps DBAs

Oadba's Blog

Category Archives: Performance & Tuning

MOS Note IDs for Tuning performance on eBusiness suite

15 Wednesday Jan 2014

Posted by oadba in Performance & Tuning

≈ Leave a comment


Time to work on some of the EBS performance, here is the complete reference of MOS IDs. All the best.

NOTE:38373.1 – TECH: Example TM(Table Locks) During Referential Integrity Enforcement
NOTE:384241.1 – Using Forms Socket Mode with Oracle E-Business Suite Release 12
NOTE:396009.1 – Database Initialization Parameters for Oracle E-Business Suite Release 12
NOTE:404954.1 – How to run OATM migration utility
NOTE:62143.1 – Troubleshooting: Tuning the Shared Pool and Tuning Library Cache Latch Contention
NOTE:62354.1 – Waits for ‘Enq: Tx – Row Lock Contention’ – Wait Scenario Examples
NOTE:94224.1 – FAQ- Statspack Complete Reference
NOTE:1020008.6 – SCRIPT: FULLY DECODED LOCKING
NOTE:1020012.6 – Script to Return Locking Information (Medium Detail) 
NOTE:122371.1 – How To Gather Statistics For Oracle Applications Prior to 11.5.10
NOTE:138159.1 – Canceling Long Running Queries in Oracle Applications 11i
NOTE:153507.1 – Oracle Applications and StatsPack
NOTE:163208.1 – bde_last_analyzed.sql – Verifies CBO Statistics
NOTE:163424.1 – How To Identify a Hot Block Within The Database Buffer Cache.
NOTE:169935.1 – Troubleshooting Oracle Applications Performance Issues
NOTE:174605.1 – bde_chk_cbo.sql – EBS initialization parameters – Healthcheck
NOTE:216205.1 – Database Initialization Parameters for Oracle Applications Release 11i
NOTE:228913.1 – Systemwide Tuning using STATSPACK Reports
NOTE:244040.1 – Oracle E-Business Suite Recommended Performance Patches
NOTE:276103.1 – Performance Tuning Using Advisors and Manageability Features: AWR, ASH, ADDM and Sql Tuning Advisor
NOTE:33453.1 – Locking and Referential Integrity
NOTE:33567.1 – TECH: ORA-1575 Timeout waiting for Space Management Enqueue
NOTE:34566.1 – WAITEVENT: “enqueue” Reference Note
NOTE:362851.1 – JVM: Guidelines to setup the Java Virtual Machine in Apps Ebusiness Suite 11i and R12

MOS note IDs related to Concurrent Processing tuning:

NOTE:1389261.1 – PCP Concurrent Manager Failover/Failback Does Not Work When Application Listener is Down On Primary Node
NOTE:1060736.1 – Deadlock Error During Concurrent Request Termination
NOTE:466752.1 – Concurrent Processing – What is FNDREVIVER and How Is It Set?
NOTE:551895.1 – Concurrent Processing – Failover Of Concurrent Manager Processes Takes More than 30 Minutes
NOTE:1360118.1 – Performance: Concurrent Requests Hang in Pending Status For Long Time
NOTE:866298.1 – Concurrent Processing – ORA-00060: Deadlock Detected – UPDATE FND_CONCURRENT_QUEUES
NOTE:1075684.1 – Concurrent Managers are consuming high CPU and memory
NOTE:1399454.1 – Tuning Output Post Processor (OPP) to Improve Performance
NOTE:844976.1 – Concurrent Processing – Concurrent Reports Failing With Errors REP-0004,REP-0082 and REP-0104
NOTE:1492893.1 – R12: Performance Issue When Standard Managers Waiting for “enq: TX – row lock contention” Held By ICM
NOTE:822368.1 – Concurrent Processing – How To Run the Purge Concurrent Request FNDCPPUR, Which Tables Are Purged, And Known Issues Like Files Are Not Deleted From File System or Slow Performance
NOTE:104452.1 – Concurrent Processing – Troubleshooting Concurrent Manager Issues (Unix specific)
NOTE:1060707.1 – Purge Concurrent Requests/Manager Data, FNDCPPUR, Not Removing Files From Filesystem

Generating & Analyzing Trace Files

13 Wednesday Oct 2010

Posted by oadba in Performance & Tuning

≈ Leave a comment


Forms Trace Files

To generate a trace file for a Form, be sure to have the profile options

Utilities: Diagnostics set to Yes
Hide Diagnostics Menu Entry set to No.

 Log on to the application, and select the 

Help ➤Diagnostic ➤Trace ➤ Trace with Binds and Waits menu option. 

After this, you should set the trace size to unlimited by selecting the following menu option: 

Help ➤Diagnostics ➤Trace ➤Unlimited Trace File Size. 

The resulting trace file will be written to the udump directory located on the Database Node. 

 

Self Service Trace Files

Self Service Tracing can be implemented by navigating to

Security ➤Profile ➤User.

Enter the user name.

Query the profile FND: Diagnostics.

Set FND: Diagnostics to Yes.

Log in to the application as the user for which the diagnostics profile was set. Click the diagnostics icon, select Set Trace Level, and click Go. On the next page, select Trace with Binds and Waits, and click Save. Perform the steps required to duplicate the problem. When this has been completed, there will be a trace file generated. This file can be located and analyzed using the techniques explained in the next section.

 Analyzing Trace Files

Once the raw trace file has been generated, execute the tkprof or trcanlzr utilities to translate it into a readable format. Descriptions for using theseutilities are provided in the following sections.

 Using tkprof

In order to run tkprof on the raw trace file, obtain the name of the generated trace file. Note that tkprof may only be executed in the database from which the trace file was originally generated. Execute tkprof as the instance owner in a directory with write permissions as follows:

 $tkprof <raw trace file name> <output filename> \ explain=apps/<apps password>

 The file generated by tkprof will contain important information regarding the SQL statement, as well as diagnostics that include CPU and elapsed time, disk and logical reads, and the number of rows returned in the query, as well as the SQL execution plan. Most likely, this file will need to be uploaded to Oracle Support for assistance in resolving the underlying performance issue.

Using trcanlzr

The Trace Analyzer utility (trcanlzr) reads a raw trace and generates an HTML report that includes tkprof analysis data as well as other statistics. The HTML file that is generated can be used by Oracle Support to assist in resolving performance issues.

To generate the HTML file, the trcanlzr utility must be downloaded from Oracle Support. It is available by referencing MetaLink Note 224270.1.

Once the utility has been downloaded, you will need to install it by following the instructions in the download.

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • February 2014
  • January 2014
  • December 2013
  • September 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • February 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • May 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • August 2010
  • July 2010
  • February 2009
  • January 2009

Categories

  • AD Utilities
  • Administration
  • Application Patching
  • Career Management
  • Certification
  • Cloning
  • DEMOs
  • Essential OS Commands
  • General
  • Installation
  • Monitoring & Troubleshooting
  • MOS Docs
  • My Oracle Support (MOS)
  • Oracle Cloud
  • Oracle Fusion Apps
  • Oracle Utilities
  • Oracle VM
  • Oracle Workflow
  • Patching
  • Performance & Tuning
  • RAC Specific
  • Scripts
  • Security
  • Troubleshooting
  • Uncategorized
  • Upgrades

Meta

  • Register
  • Log in

Blog Stats

  • 86,082 hits

OADBA Blog Search

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« May    
Locations of visitors to this page

Documentation

  • Release 12.1 Documentation Library

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Oadba's Blog
    • Join 239 other followers
    • Already have a WordPress.com account? Log in now.
    • Oadba's Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...