| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Lock waits even though nothing in v$session.lockwait ... ?
It's probably because you haven't waited long enough for PMON to wake up. You can manually wake it up by go inyo svrmgrl, type oradebug wakeup [pmon pid as shown in ps -ef at OS level].
Let us know if it helps.
Can you also show us the relevant portion of your v$resource_limit?
Yong Huang
yong321_at_yahoo.com
"Andy Kent" <andykent.bristol.DontSpamMe_at_virgin.net> wrote in article
<gcVo6.12430$mt.2044444_at_news2-win.server.ntlworld.com> :
>How do you tidy up after a system has become beset with lock waits and 'out
>of DML locks' errors?
>
>This afternoon our processes all remained resolutely frozen and the locks
>remained on even after the session that caused all the locks to back up
>behind it had been killed. The strangest thing was that all the processes
>just sat there even though there was not one single non-null value in
>v$session.lockwait.
>
>I thought I knew my way around the Oracle server pretty well but I must
>admit I became very confused about how I should be approaching the problem,
>and I couldn't find anything of help in the HTML manuals.
>
>Can someone offer me some pointers please?
>
>And why was I getting 'out of DML locks' errors at 630 locks even though our
>total configured number is in the 10000's?
>
>--
>-Andy Kent-
>Bristol, England
>
>Remove '.DontSpamMe' from return address to respond.
>
>
>
 |
 |