Re: Dead-lock...

From: Stefan <sroesch3_at_attbi.com>
Date: Fri, 11 Jan 2002 07:38:02 GMT
Message-ID: <uDw%7.24664$762.224006@rwcrnsc54>

Hi Andy,

if this doesn't help what Sybrand proposed make two consective systemstate dumps and look if the wait events are changing. Also look for what events it is waiting.

Regards
Stefan

Sybrand Bakker wrote:

> On Thu, 10 Jan 2002 15:32:25 GMT, news_at_info-line.it (andy) wrote:
>

>>On Oracle 8.0.6 installed on a IBM AIX server with parallel server
>>option, sometimes i can see a strange thing. All the applications
>>running go in a wait-state, without error message.
>>From an sql editor if i try to CREATE TABLE... i wait, i
>>wait...nothing happens.
>>The only way to restore normal condition is to restart the Oracle
>>instance.
>>Note that in the applications there are some Delphi DDL commands that
>>manipulate Oracle tables.
>>
>>Any ideas?
>>
>>Best regards. Andy.

>
>
> You would of course need to do the following
> - find out the sid and serial# of the hanging session.
> This can be done by selecting (in a different session) from the
> v$session table and/ or v$process and/or v$open_cursor.
> This would allow you to kill the session
> (alter system kill session '<sid,serial#>' without restarting the
> Oracle instance, which is definitely completely unnecessary to resolve
> your problem.
> - You could of course use v$session_wait to see what your process is
> waiting for
> - or look into v$lock to see if there are locks. If you run the
> catblock.sql script (as you -as many others- didn't include a version
> and a platform I can't be more specific). This will create the
> dba_blockers view, which will show whether and which processes are
> excluding each other.
> BTW: with 12 year Oracle experience I have never seen this behavior,
> so it looks lik you have other and more serious problems.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Jan 11 2002 - 01:38:02 CST