Performance Tuning Overview in Oracle Apps 11i Contd..

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
http://becomeappsdba.blogspot.com/2006/09/performance-tuning-apps-11i.html

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)

About the Author Atul Kumar

Leave a Comment:

8 comments

agostino_neto says November 15, 2006

Atul,
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).

Atul Kumar says November 15, 2006

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

Atul

agostino_neto says November 15, 2006

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 ?

Atul Kumar says November 16, 2006

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

Anonymous says March 14, 2007

Hi Atul

as in one of your post at teachmeoracle.com, 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

Regards
Harkirat

Atul Kumar says March 14, 2007

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

Atul

Prasad says August 3, 2007

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
Prasad

Atul Kumar says August 3, 2007

For any apps quesries/questions / doubts raise them in forum at http://teachMeOracle.com/forum

Add Your Reply