John,
I know this is an old topic, but Oracle Support proposed a patch and we finally got
it tested. It looks like this enqueue wait goes away with the application of
concurrent processing rollup patchset C 2385942.
Thanks,
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA USA
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
Here is the output from the query:
Sid/Ser# DB/OSUser StartTime Mins Rbs NameBlks Status
-- --- -- -- -
14/106 APPS/applmgr12/06/02 01:29:32 518 RBS2 1 ACTIVE
33/537 APPS/applmgr
, 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
Jay,
You may want to refer to Metalink Doc Id #29787.1 and 34566.1. Those will explain
what p2, p3 are in an enqueue wait. Unfortunately, those will not discuss p2, p3 for
UL :(
I know nothing about Oracle Apps (11i). May be John K. could comment on that.
- Kirti
-Original Message-
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