Performance

[latifa]

Hi Erman,

How to check poor performance of the application ?  disconnections ?


we have EBS r12.2.4. 2 servers for CMs (concurrent managers), 2 servers Weblogic, forms, etc, .. and 2 OHS (Web). For DB, we are in RAC  12c Release 12.1.0.2.0.


Thank you in advance for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

Hi Latifa,

This is a very generic question.

It is a big subject, but as you can guess, you will have to check the peformance of all the tiers and components indiviually.

As for App ->

Oracle Concurrent Processing Analyzer – Doc ID 1411723.1
Express Diagnosis of Oracle E-Business Suite Release 12 Upgrade Performance Issues Note 1583752.1
Oracle E-Business Suite Recommended Performance Patches Note 244040.1
Oracle Fusion Middleware - Performance and Tuning for Oracle WebLogic Server 11g Release 1 (10.3.6)
12.2 Debgging Managed Server Performance and Stability Note 1908444.1 Internal Only
PRACTICAL ORACLE E-BUSINESS SUITE -> CHAPTER 13 ORACLE E-BUSINESS SUITE 12.2 PERFORMANCE RECOMMENDATIONS

As for DB ->

Troubleshooting Oracle E-Business Performance Problems Using the Database Diagnostics and Tuning Features (Doc ID 1540650.1)

PRACTICAL ORACLE E-BUSINESS SUITE -> CHAPTER 13 ORACLE E-BUSINESS SUITE 12.2 PERFORMANCE RECOMMENDATIONS

You also need to ensure that the best practices are applied.

[latifa]

Hi Erman,

Thank you for your feedback.

I found some error messages in the following log:

oacore_server22.out

oacore_server22.out

Could you please advise me error messages in this file.

I found one of them, so I said it could be network issue , may be.

Thank you in advance

Regards,

[latifa]

Hi Erman,

We have also a request failing with erro message that I can't find explaination:

logfile of the request:

... fs1/EBSapps/appl/fa/12.0.0/bin/FARET
usdsop cannot create new requests

Cause : usdsop detected an error while creating a new request. [Reason].

Action :Check that the system has enough resources to execute new request. Contact (RE

--> what is usdsop ? What does it mean ?

Thanks in advance for your help.

Regards

[ErmanArslansOracleBlog]

Check -> CMCTCM - usdsop cannot create a new process (Doc ID 1360701.1)

[latifa]

Thank you Erman for your reply.

However, this note concern Cost Manager. How to know which manager is affected by this issue. How can we find it accailing requests.

Regards

[latifa]

The system was working fine. why we should increase processes number now.

I heard that the swap was used at 100% in one node of DB RAC ! could it explian this behavior.

Regards

[ErmanArslansOracleBlog]

Yes Latifa..
I realized that later..
But ,as you may also already checked ,  that document (although it is written for CMCTCM) states -> "Increase the number of processes as required."

That document is also related with usdsop and usdsop plays role during spawn, fork or you name it, let say exec..

So it is a resource dependent thing and that's why OS is a good place to check..

I see that you catched a good point with that swap usage, so that can be the reason..
Being unable to create a new process in OS level (which might be caused by the insufficiency in several type of resources) might be the reason..

So you are in the right track..

[latifa]

Hi Erman,

customers are disconnected with followin error message:

 FRM-92100: your connection to the server was interrupted
Possible causes: network error or server failure. You should restore your session.

I found a DI 2299222.1 who asks to apply a patch but I am not that is the solution.

Thanks in advance for your help.

Regards,
Latifa

[latifa]

I am sorry, It doesn't ask to apply a patch. It's because a patch was applied (may be and I don't if it was applied a patch or not) and the forms libraries were not generated well.

Can I do the solution in working hours ?

Regards

[latifa]

The note ask to generate form files. Should I do it for all the products ? this note talks about "quoting patch" so product libraries were indicated as : qot,aso

Regards

My screen:

AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 920 workers.
Oracle recommends that you use between 112 and 448 workers.


Enter the number of workers [112] :

Your current character set is "WE8ISO8859P15".

Do you want to generate Oracle Forms objects
using this character set [Yes] ?


Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ?

Do you want to regenerate Oracle Forms menu files [Yes] ?

Do you want to regenerate Oracle Forms executable files [Yes] ?

Enter list of products ('all' for all products) [all] : ????

[latifa]

I have done it for all :) let us see if they will have more disconnexions.

[ErmanArslansOracleBlog]

Hi Latifa,

weekend break :)
But it seems you've gone a long way.
Good for you.

You can update this issue if it appears again.