Dead-lock...

One other thing to look at is the alert log. Check it for messages which indicate that the arch process cannot archive a logfile (due to no space or similar) and this will put the database in a hang mode with no messages.

Could be worth a try - I've had it myself. VEry puzzling the first time, but easy peasy the second :o)

Regards,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

-----Original Message-----

From: news_at_info-line.it (andy) [mailto:news_at_info-line.it] Posted At: Thursday, January 10, 2002 3:32 PM Posted To: server
Conversation: Dead-lock...
Subject: Dead-lock...

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. Received on Fri Jan 11 2002 - 02:17:37 CST