Re: SHUTDOWN: waiting for logins to complete.

From: John P. Higgins <jh33378_at_deere.com>
Date: Mon, 21 Sep 1998 20:18:28 -0500
Message-ID: <3606FAE3.F82AACCD@deere.com>

Shutdown immediate terminates all sessions and rolls back all current transactions. If a transaction had been updating for 30 minutes without a commit, it could take 30 minutes to roll back.

Anyone have other ideas?

Stuart Walker wrote:

We're running Oracle 7.3.3.5.1, and got the above message(multiple
times) when attempting to perform a shutdown immediate.  This message
appeared once in the alert log, and multiple times in a trace file for
an Oracle client.  Basically the shutdown took about 30 minutes,
eventhough there was no database activity.  Any ideas?

Regards,

Stuart Walker
Westpac Banking Corp

  Received on Mon Sep 21 1998 - 20:18:28 CDT