RE: Is there a better way to confirm whether Conc.Managers are up and running?
- From: "Fadi Hasweh" <fhasweh@xxxxxxxxxx>
- To: <naqimirza@xxxxxxxxx>, <vikramsingh120@xxxxxxxxx>, "freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Mar 2007 12:25:48 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Naqi Mirza
Sent: Wednesday, March 28, 2007 9:35 AM
To: vikramsingh120@xxxxxxxxx; freelists
Cc: ora-apps-dba-request@xxxxxxxxxxxxx
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
----- Original Message ----
From: vikram singh <vikramsingh120@xxxxxxxxx>
To: freelists <oracle-l@xxxxxxxxxxxxx>
Cc: ora-apps-dba-request@xxxxxxxxxxxxx
Sent: Wednesday, 28 March, 2007 7:27:51 AM
Subject: Is there a better way to confirm whether Conc.Managers are up
and running?
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
----
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!
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."
Other related posts:
