Solved

APPS9 Performance Tuning

  • 17 February 2021
  • 6 replies
  • 213 views
CUCSOLUTIONS
Rank
Userlevel 3
Badge +7

Is there documentation on APPS9 performance tuning?

Specifically when it comes to optimizing database tasks & db tuning?

Any documents on best practices?

Our IFS env are VMs running Windows 2012 server R2. We are running Oracle 12.1 with 3 prod db instances on the same server. We are considering an oracle upgrade to 19, but first I need to apply IFS UD17, although UD16 is only required,

I felt I may as well update to the latest version. Anyone have any bad experiences with UD17? I had several issues with UD14 applying and ended up with a fresh build from IFS.

With the recent lag in performance, I have reservations regarding applying updates.

Much appreciate the feedback.

icon

Best answer by Mohamed Infaz 18 February 2021, 14:45

View original
This topic has been closed for comments

6 replies

NickPorter
Rank
Userlevel 6
Badge +18

You’ve got a lot in the question and I can’t quickly speak to the Oracle tuning recommendations, but UPD17 seems mostly OK.  We are in process of testing from a MUCH earlier UPD level.

We had a few custom objects and views simply disappear, which was weird, and at least one of the core views we use for Purchase Order reports was renamed which broke our custom plugin layout until we found the root cause, but other than that we’ve had no major impacts.

Stating the obvious… Just be sure to plan and execute full business process validation in Test to ensure it looks good before rolling into Prod.  The little things are the items that we saw get in the way.

CUCSOLUTIONS
Rank
Userlevel 3
Badge +7

Nick;

Thank you for the comment.

Fingers crossed - all goes well.

 

Mohamed Infaz
Rank
Userlevel 5
Badge +10

Hi @CUCSOLUTIONS ,

 

As nick has stated, there is no easy or one way of doing this, but if you are facing a recent lag in performance, try to analyze whether it is an overall performance drop or certain forms/processes are the culprits. I believe it’s better if you can take an AWR report or a stats pack report depending on the oracle licenses you have, which would give you a better picture of what has happened to the system. 

Cheers, Infaz.
CUCSOLUTIONS
Rank
Userlevel 3
Badge +7

I know about the stats pack - what is the AWR? We are running Oracle 12.1 Standard, so have no Oracle monitoring tools we can use. Our Oracle support is through IFS.

Thx again for the feedback in this conversation.

 

Mohamed Infaz
Rank
Userlevel 5
Badge +10

Hi @CUCSOLUTIONS ,

it stands for Automatic workload repository.

 

https://www.oracle.com/technetwork/database/manageability/diag-pack-ow09-133950.pdf

Cheers, Infaz.
NickPorter
Rank
Userlevel 6
Badge +18

Be careful with AWR - if you have Standard Edition I believe you may not have the right to use AWR.  I think that requires Enterprise Edition but you should confirm and ensure that you remain compliant.

Nick

Terms & ConditionsCookie settings