| 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: Enqueue Waits in Oracle Financials
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?
> -----Original Message-----
> From: Jay Hostetter [mailto:jhostetter_at_decommunications.com]
> Sent: Friday, December 06, 2002 8:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Enqueue Waits in Oracle Financials
>
>
> Here is the output from the query:
>
> Sid/Ser# DB/OSUser StartTime Mins Rbs Name
> Blks Status
> ---------- --------------- ------------------ ---- ----------
> ----- ------------
> 14/106 APPS/applmgr 12/06/02 01:29:32 518 RBS2
> 1 ACTIVE
> 33/537 APPS/applmgr 12/06/02 07:59:42 128 RBS11
> 1 ACTIVE
> 160/285 APPS/applmgr 12/06/02 09:29:01 39 RBS10
> 1 ACTIVE
> 165/234 APPS/applmgr 12/06/02 09:58:54 9 RBS14
> 1 ACTIVE
> 71/240 APPS/applmgr 12/06/02 10:07:24 0 RBS24
> 1 ACTIVE
> 45/2 APPS/applmgr 12/06/02 10:07:37 0 RBS8
> 1 ACTIVE
> 83/280 APPS/applmgr 12/06/02 10:07:42 0 RBS27
> 1 ACTIVE
>
> 7 rows selected.
>
>
> The offending SID today is 16, which I don't see in the
> output from the above query.
>
> SQL> run
> 1 select sid,
> 2 event,
> 3 total_waits tws,
> 4 total_timeouts tt,
> 5 time_waited tw,
> 6 average_wait avgw
> 7 from v$session_event
> 8 where event = 'enqueue'
> 9* order by time_waited desc,event
>
> Sess Total Total
> Time (ms) Avg (ms)
> ID Wait Event Waits Timouts
> Waited Wait
> ----- ------------------------------------- -------- -------
> --------- --------
> 16 enqueue 5594 5589
> 572543 102
> 10 enqueue 1 0
> 13 13
> 45 enqueue 1 0
> 12 12
>
> I map this SID (16) back to the Internal Manager. By the
> way, SID 14 (with the highest "Mins" in your query) is the
> Service Manager.
> We scaled back our Alert manager to 1 process because we
> replaced some of our Alerts with triggers. The Alerts where
> just too much of a performance problem on our system (they
> were over 1/2 of our concurrent requests).
> Do we have any "new fangled" modules? Yes. Service and Contracts.
> Are we using OAM? It is installed, but we're not using it.
> I stumbled into it already and brought up some pretty graphs.
>
> Thanks,
> Jay
>
>
> >>> john.kanagaraj_at_hds.com 12/05/02 07:39PM >>>
> Jay,
>
> Does this come from the alert manager? Do you have any of
> those new-fangled
> 11i modules (or should I call the 'mangled'!!). You could use
> the script
> below (adapted from Govind who posted this a few days back)
>
> set pages 100
> column sid_serial format a10 heading "Sid/Ser#"
> column username format a15 heading "DB/OSUser"
> column start_time format a18 heading "StartTime"
> column mins_pending format 999 heading "Mins"
> column used_ublk format 9999 heading "Blks"
> column name format a10 heading "Rbs Name"
> column status format a12 heading "Status"
> select sid || '/' || serial# sid_serial, username || '/' ||
> osuser username,
>
> substr(t.start_time,1,18) start_time,
> round( ( sysdate - TO_DATE( start_time, 'MM/DD/YY HH24:MI:SS')
> ) *24*60 ,0 ) mins_pending,
> r.name, t.used_ublk ,
> decode(t.space, 'YES', 'SPACE TX',
> decode(t.recursive, 'YES', 'RECURSIVE TX',
> decode(t.noundo, 'YES', 'NO UNDO TX', t.status))) status
> from v$transaction t, v$rollname r, v$session s
> where t.xidusn = r.usn
> and t.ses_addr = s.saddr
> order by t.start_time
> /
>
> If the OS user turns out to be 'applmgr' for any waiting TXN
> then pursue
> this from the CM side. Otherwise, you can look at the Forms
> users. In any
> case, are you using OAM (Oracle Applications Manager)?
>
> John Kanagaraj
> Oracle Applications DBA
> DB Soft Inc
> Work : (408) 970 7002
>
> Listen to great, commercial-free christian music 24x7x365 at
> http://www.klove.com
>
>
>
>
>
> **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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.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 Fri Dec 06 2002 - 18:13:41 CST
 |
 |