Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about what to do about the abnormal concurrent manager and slow cmclean.sql after shutting down EBS. Many people may not know much about it. In order to make you understand better, the editor summarized the following content for you. I hope you can get something according to this article.

Generally speaking, after the shutdown of EBS R12.1, there may be many scheduled job processes running at a later stage without ending, and some of the information about these runs is saved in the database, so we need to do some actions before reopening EBS to clean up some data in the database and see if the processes are all finished.

Ps-ef | grep applxxxx

Kill the user process under linux

Ps-efww | grep applgsit | grep-v grep | cut-c 9-15 | xargs kill-9

Kill the user process under AIX

Ps-ef | grep "applgsit" | grep-v grep | awk'{print $2}'| xargs kill-9

It's a good idea to run the cmclean.sql script before opening it to clean up some information about concurrent mananger in the database.

The concurrency number of concurrency managers can also be changed according to actual needs (after opening form, Concurrent-> mananger-> Define-> F11, and then enter the manager name you want to set, such as Standard%, ctrl+F11 query, click the workshift button to set the number of concurrency).

Note: if running cmclean.sql is very slow, there may be lock or dead lock problems, which need to be queried

Select sid, serial# from v$session where program like'% ICM%', then use the

Alter system kill session 'SID,SERIAL#'; kill. Just continue to run cmclean.sql.

After reading the above, do you have any further understanding of what to do if there is a concurrent manager exception and a slow cmclean.sql problem after reopening EBS? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.