John,
Yes, the PMON method is lock.
The ICM runs 1 process with a sleep time of 30 seconds and a null value for cache
size. All of our managers sleep at least 30 seconds, with the exception of a
Service Manager, which is null.
I'll probably end up logging a TAR.
Thanks,
Jay
>>> [EMAIL PROTECTED] 12/06/02 07:13PM >>>
Jay,
Is the PMON method set to LOCK? See the output of the following SQL
select profile_option_value from applsys.Fnd_Profile_Option_Values
where Level_ID = 10001
And Level_Value = 0
And Application_ID = 0
And Profile_Option_ID = ( Select Profile_Option_Id
From apps.Fnd_Profile_Options
Where Profile_Option_Name =
'CONC_PMON_METHOD')
I believe the ICM (Internal Concurrent Manager) places its own locks for
scheduling reasons - maybe that is why you are seeing UL locks. You might
also want to check with the Apps SYSADMIN account holder if anything has
been changed wrt scheduling (could be the Cache size or Sleep seconds for
any of the managers). You can verify if something has been changed by
looking at the LAST_UPDATE_DATE on most FND tables.
Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
What would you see if you were allowed to look back at your life at the end
of your journey in this earth?
** The opinions and statements above are entirely my own and not those of my
employer or clients **
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the
individual or entity to which they are addressed and may contain information that is
privileged, proprietary and confidential. If you are not the intended recipient, you
may not use, copy or disclose to anyone the message or any information contained in
the message. If you have received this communication in error, please notify the
sender and delete this e-mail message. The contents do not represent the opinion of
D&E except to the extent that it relates to their official business.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
