| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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?
Dear vikram
Oracle supplies several useful scripts, (located in $FND_TOP/sql directory), for monitoring the concurrent managers:
afcmstat.sql
Displays all the defined managers, their maximum capacity, pids, and their status.
afimchk.sql
Displays the status of ICM and PMON method in effect, the ICM's log file, and determines if the concurrent manger monitor is running.
afcmcreq.sql
Displays the concurrent manager and the name of its log file that processed a request.
afrqwait.sql
Displays the requests that are pending, held, and scheduled.
afrqstat.sql
Displays of summary of concurrent request execution time and status since a particular date.
afqpmrid.sql
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.
afimlock.sql
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
Fadi
http://oracle-magic.blogspot.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Naqi Mirza
Sent: Wednesday, March 28, 2007 9:35 AM
To: vikramsingh120_at_gmail.com; freelists
Cc: ora-apps-dba-request_at_freelists.org
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
Hi,
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
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!
Regards/Vikram.
Copy addresses and emails from any email account to Yahoo! Mail - quick,
easy and free. Do it now...
<http://us.rd.yahoo.com/mail/uk/taglines/gmail_com/trueswitch/*http:/uk.
docs.yahoo.com/trueswitch2.html>
"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."
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 28 2007 - 05:25:48 CDT
 |
 |