Urgent: PL/SQL lock timer event

Hi,
 I need urgent assistance is resolving issues with PL/SQL lock timer. My query is waiting on this event more than an hour. waited duration is incrementing when I query v$session_wait.  Do you know what this PL/SQL lock timer event is? why my query is waiting on this event for so long? How do resolve this?  We are on v7.3.4.5.0 on HP-UX 11.0
Your help is appreciated.

 132        672 PL/SQL lock timer
duration                                                                300
0000012C
                                                                         0
00
                                                                          0
00     301     2555 WAITED KNOWN TIME

Thanks
Sandesh

-----Original Message-----
Sent: Thursday, May 31, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L

No doubt Novell at the time was more stable than NT at the time.

But some of these stories, which can start off as "My Novell box seems more stable than that NT 3.51 SP 1 box" mutate into internet apocrypha faster than you can spell "telephone".

Before you know it, it's a heartlung machine, coded in assembler, running on a Novell beta release cross compiled to the Kaypro, which has been up, even through tornadoes, for 22 years. Meanwhile, the NT box crashed on boot up, then corrupted the disk, sold the house, and slept with my wife.

I always ask for details. Two reasons. The first is to take a litmus test for veracity. The other is (assuming veracity) to learn something about how to make systems stable. <shrug>

|| -----Original Message-----
|| From: Eric D. Pierce [mailto:PierceED_at_csus.edu]
|| Sent: Wednesday, May 30, 2001 5:48 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: backspace in Oracle.
||
||
|| that would be if the stupid (HELP) data janitor remembers to do
|| VREPAIR once every other month or so. sometime the stupid data
|| janitor forgets and only does it once a year (with no other
|| downtime).
||
|| in other words, except for occasional/normal piddly maintenance
|| (which is not otherwise required to keep the system up), netware3x
|| will not typically experience the same thing as the (supposedly)
|| infamous NT reboots.
||
|| ???
||
|| ep
||
|| On 30 May 2001, at 13:10, Mohan, Ross wrote:
||
|| Date sent: Wed, 30 May 2001 13:10:37 -0800
|| To: Multiple recipients of list ORACLE-L
|| <ORACLE-L_at_fatcity.com>
||
|| > I am all for NLMs, DLMs, and M&M.
|| >
|| > But, if you let me bounce most any NT box
|| > once a month for, say, a DEFRAG, I'll be
|| > able to keep it up for one helluva long
|| > time too.
|| >
|| > Ross NMN Mohan
|| >
|| > || -----Original Message-----
|| > || From: Eric D. Pierce [mailto:PierceED_at_csus.edu]
|| > || Sent: Wednesday, May 30, 2001 4:03 PM
|| > || To: Multiple recipients of list ORACLE-L
|| > || Subject: RE: backspace in Oracle.
||
|| ...
||
|| > || Only reason for "downtime" is running VREPAIR (rough
|| equivalent of
|| > || "scandisk") about once every other month, and also when
|| the startup
|| > || files need maintenance (usually related to changed
|| parameters on
|| > || .nlms loaded, versoin upgrades, etc) and a bounce is
|| required. also
|| > || we recently had to put in a new UPS battery, which
|| required a down.
||
|| ...
||
||
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Eric D. Pierce
|| INET: PierceED_at_csus.edu
||
|| Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|| San Diego, California -- Public Internet access /
|| Mailing Lists
|| --------------------------------------------------------------------
|| 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: Mohan, Ross
  INET: MohanR_at_STARS-SMI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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: Naik, Sandesh S
  INET: sandesh.naik_at_qwest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).