We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Performance Tuning Overview in Oracle Apps 11i Contd.. |
| Tuesday, September 05, 2006 |
|
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) |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 5:12 PM
  |
|
| 11 Comments: |
-
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).
-
I didn't understand what you are saying to be frank.
Atul
-
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 ?
-
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
-
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
-
error_log contain any error message your web server encountered during its operation as well start stop information
Atul
-
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
-
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.
-
Hi
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?
Thanks
ANUP
-
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..
-
Can anyone recommend the best Managed Service tool for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: [url=http://www.n-able.com] 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!
|
| |
| << Home |
| |
|
|
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).