Someone is doing:
dbms_lock.sleep(x)
where 'x' is seconds. It won't be causing any
performance problems - its a 'quiet' wait
hth
connor
- "Naik, Sandesh S" <sandesh.naik_at_qwest.com> wrote:
> 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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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).
Received on Thu May 31 2001 - 16:32:40 CDT