-
Tune Oracle APPS R12
Hi
I have to tune Oracle APPS R12. Can some one guide me in this regard
Thanks in Advance
-
-
Hi Stecal
I have to Tune Oracle Applications Release 12. For this purpose i wanted some guidance.
Regards
-
Originally Posted by nadirpervez
I have to Tune Oracle Applications Release 12. For this purpose i wanted some guidance.
Too broad of a question, this exceeds what can be addressed in a forum thread... entire books - literally - address this matter, like http://www.amazon.com/Oracle-Applica.../dp/0072125497
Last edited by PAVB; 05-09-2010 at 02:28 PM.
Reason: typo
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
we shall ask again
tune what?
-
Hi,
My question is still there. I know about database administration but i want to know if there is any document available regarding the tuning of Oracle Applications Release 12.
Oracle Applications Release 12 consists of the following components:
1. Oracle Database 10g
2. Oracle Forms Server
3. Oracle Reports Server
4. Oracle HTTP Server.
I want to tune all of these components. If any one knows please let me know.
Regards
-
tune what though, you haven't said what the problem is!
you can't tune something without a problem
-
Hi
Actually my Oracle Appliations R12 is not giving good performance and therefore i have to tune it. Thats why i posted this question.
Forms, Reports and self service forms are taking too much time.
I don't know where to start from.
Regards
-
Originally Posted by nadirpervez
I don't know where to start from.
Well... you have to choose a target to take your shot.
Was the system performing fine then suddlendy started to perform poorly? what changed?
Look at disk I/O... look for I/O contention.
Look at CPU status... are they in User? Idle? or Wait state most of the time?
Run AWR report and look at wait events, I/O
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|