Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database
  • Upgarde DB to
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management

  • We have moved to kindly check http://onlineAppsDBA.comin future
    Performance Tuning Overview in Oracle Apps 11i Contd..
    Tuesday, September 05, 2006
    Register for R12 upgrade
    This Performance Tuning is an Overview of from where to start if users start complaining
    that Oracle Applications is running slow. If you have not read previous post on
    Performance Checks on 11i visit

    If performance issue is with entire application questions you should have in mind
    Is your applications sized properly ?
    Is initialization parameters set up correctly ?
    Are there any runaway processes in oracle database tier or application tier ?
    Is network connectivity between users & application server is fine , there is no delays ?
    Latest techstack including jdbc drivers, forms, database, jdk can improve performance
    considerably Check if system level trace is enabled ?
    Is Purge schedule ?
    Is gather stats scheduled ?

    If Issue is with only particular type of reports
    Check if there are no performance bugs with that module ?
    Are you on latest patchset for that product ?
    Is it standard report or custom ? (If custom enable trace & use tkprof, If standard then
    check in metalink if there is any issues reported by others)
    If Issue is only during particular time lets say during night Check what's running during that time Is it because of backups ?
    Is it because all resource intensive requests running in night ?

    If Issue is with specific users Check
    if trace is enabled at user level ?
    Is user client machine performing well ?
    Is connectivity from client machine to server fine ?

    This is just overview or starting point to check Performance Issues in Oracle applications
    11i for Tuning Individual component like , Apache, JVM, Concurrent manager I'll post in my
    future posts.

    One of reader asked how to schedule Gather Stats or How to schedule Purge Concurrent
    Program or Obsolete workflow data.
    These are concurrent requests & if you have "System Administrator Responsibility" login
    with that then go to Request -> View -> Select "Specific Request" and under "Name" Text
    Search for following requests
    Gather Schema Statistics ( supply parameter schema name , apps & others)
    Purge Concurrent Request and/or Manager Data ( supply retention period usually 90 days)Purge Signon Audit data
    Purge Obsolete Workflow Runtime Data
    Purge Obsolete Generic File Manager Data
    If you are not aware of what is concurrent request or how to check don't worry wait for sometime till we come to sysadmin section & I'll update what to read & from where to read about Oracle Application Sysadmin related to concurrent requests.

    If you want to understand How to proceed with Oracle Applications 11i tuning check Metalink Note 69565.1 A Holistic Approach to Performance Tuning Oracle Applications Systems (Though quite old guide from year 2001 but good for approach)

    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 5:12 PM  
    • At 3:55 PM, Anonymous agostino_neto said…

      Can you tell us which programs we can schedule without asking to users or any one ?
      Because for Purge Concurrent Request and/or Manager Data, I suppose we should see with users first.
      Also can you tell us what your preference is? Scheduling those programs directly using eBusiness Suite? or using UNIX cron for example (with CONCSUB or FND_REQUEST).

    • At 6:33 PM, Blogger Atul Kumar said…

      I didn't understand what you are saying to be frank.


    • At 10:34 PM, Anonymous agostino_neto said…

      I am talking of the following concurrent programs:
      Gather Schema Statistics
      Purge Concurrent Request and/or Manager Data
      Purge Signon Audit data
      Purge Obsolete Workflow Runtime Data
      Purge Obsolete Generic File Manager Data
      The question is will some users ask for data purged by those concurrent programs ?
      Another question is where are you actually scheduling those programs ?

    • At 6:16 AM, Blogger Atul Kumar said…

      Oh Neto yes Gather stats you can run at your run but for purging

      You should consult functional & management about how much data they want to keep in system as purging will delete old log or workflow data already processed

      Another question is where are you actually scheduling those programs ?

      You need to do it via "submit Concurrent Request " screen from frontend

    • At 10:21 AM, Anonymous Anonymous said…

      Hi Atul

      as in one of your post at, you have explained beautifully about the contents of $IAS_ORACLE_HOME/Apache/Apaceh/logs/access_log file
      Can you explain the purpose of $IAS_ORACLE_HOME/Apache/Apaceh/logs/error_log file and explain the contents of this file


    • At 10:48 AM, Blogger Atul Kumar said…

      error_log contain any error message your web server encountered during its operation as well start stop information


    • At 6:34 PM, Anonymous Prasad said…

      Hi Atul,

      I am having issue with autoinvoice import program performance after 9i to 10g upgrade.

      It is taking about 16 hours to process 200,000 records.

      Have you encountered/came across this issue?

      Please advice.

      Thank you

    • At 7:03 PM, Blogger Atul Kumar said…

      For any apps quesries/questions / doubts raise them in forum at

    • At 10:14 AM, Anonymous Anonymous said…

      Hi Atul,

      Can you please tell me how to archive data before purging?

      I want to save all concurrent requests data before start "Purge Concurrent Request and/or Manager Data". I want to save these data in our custom table.

      Please let me know if there is anyway to do this.

    • At 11:10 AM, Anonymous anup said…


      How to check following performace related issue in apps:

      1. Trace is enabled at user level or Not?
      2. user client machine performing well or not?
      3. Is connectivity from client machine to server fineor not?


    • At 2:46 PM, Blogger ASH said…

      Hi Atul,
      If I schedule the program "Purge Obsolete Workflow Runtime Data" for longer period say 12 weeks , What will be the negative influence on storage performance and how to check it ?? Could you please lighten me regarding this..

    • At 8:21 AM, Anonymous Anonymous said…

      Can anyone recommend the best Managed Service tool for a small IT service company like mine? Does anyone use or How do they compare to these guys I found recently: [url=] N-able N-central server management
      [/url] ? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!

    Post a Comment
    << Home
    About Me

    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Only search this Blog
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Add On

    Add to Technorati Favorites



    Add to Google


    Add to My AOL


    Subscribe in Bloglines


    Subscribe in NewsGator Online

    Powered by

    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Copyright © 2006 All rights reserved Presented by Atul Kumar