Re: Dead-lock...

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 Thu Jan 10 2002 - 09:52:38 CST