Oracle-L: RE: Enqueue Waits in Oracle Financials

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Mon, 09 Dec 2002 11:44:31 -0800
Message-ID: <F001.005157AA.20021209114431@fatcity.com>

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

>>> john.kanagaraj_at_hds.com 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: jhostetter_at_decommunications.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Dec 09 2002 - 13:44:31 CST