Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is there a better way to confirm whether Conc.Managers are up and running?

RE: Is there a better way to confirm whether Conc.Managers are up and running?

From: Fadi Hasweh <>
Date: Wed, 28 Mar 2007 12:25:48 +0200
Message-ID: <5D3BF5596805DF448AE69C2D6277FE79071674@HQ-UM-EXCH.UMNIAH.COM>

Dear vikram

Oracle supplies several useful scripts, (located in $FND_TOP/sql directory), for monitoring the concurrent managers:  


Displays all the defined managers, their maximum capacity, pids, and their status.


Displays the status of ICM and PMON method in effect, the ICM's log file, and determines if the concurrent manger monitor is running.  


Displays the concurrent manager and the name of its log file that processed a request.


Displays the requests that are pending, held, and scheduled.


Displays of summary of concurrent request execution time and status since a particular date.


Displays the operating system process id of the FNDLIBR process based on a concurrent request id. The process id can then be used with the ORADEBUG utility.


Displays the process id, terminal, and process id that may be causing locks that the ICM and CRM are waiting to get. You should run this script if there are long delays when submitting jobs, or if you suspect the ICM is in a gridlock with another oracle process.

You may find what you need inside one of them  


[] On Behalf Of Naqi Mirza Sent: Wednesday, March 28, 2007 9:35 AM
To:; freelists
Subject: Re: Is there a better way to confirm whether Conc.Managers are up and running?  

Apart from sql, what about the form - administer concurrent manager - from the sysadmin responsibility


There is a need for a SQL that will report if all conc.managers are up and running. The SQL should gather information about which concurrent managers are enabled, whether the 'Actual' and 'Target' values match for that conc.manager, and if they do not it should be reported.

 We use a shell script now something similar to

ps -aef | grep FNDLIBR | grep `whoami`

 The above script has a couple of limitations like: 1. It will show whether FNDLIBR process is alive or not, but it doesn't throw light whether all the enabled concurrent managers are up and running.
2. This shows the FNDLIBRs for that current user. But in one of our setups we have more than one application attached for a single 'applmgr' account. We only source env files to work on a particular application.  i.e., we "su - applmgr" to the user, then we will source the env for either InstanceA or InstanceB depending on the need.  This setup makes it difficult for us to use the above shell
"ps -aef | grep FNDLIBR | grep `whoami`" script as this will not report
the presence of conc.managers for a particular instance.

Is there a better way i can track the Conc.Managers in the application?

Is there a good SQL that captures all the relevant information and which can be used within a shell script to be run periodically?

I am also open to any other idea that you may have to simplify the process.

Don't you think there ought to be a better idea? There might be of which i may not be aware of. Please enlighten!


Copy addresses and emails from any email account to Yahoo! Mail - quick, easy and free. Do it now...

"This email is intended for the above named addressee (s) only and may contain confidential and/or privilege information and should not be used by anyone who is not the original intended recipient(s). Any review, print, copy, reliance or distribution by others or forwarding without express permission is strictly prohibited If you have received this email in error, kindly notify the sender immediately by reply email and delete this email and any attachments from your mailbox or any other storage mechanism. Thank you.
Email transmission cannot be guaranteed to be secured or error free, as information could be intercepted, corrupted, lost, destroyed, received late or incomplete, or could contain viruses. The sender therefore does not accept liability for any error or omission in the contents of this message, which arises as a result of email transmission. Opinions, conclusions and other information in this message that do not relate to the official business of Umniah Mobile Company and is not its responsibility shall be understood as neither given nor endorsed by the organization."

Received on Wed Mar 28 2007 - 05:25:48 CDT

Original text of this message