Urgent: Oracle 8 parallel server on VMS 7

From: Harald Thienel <harald_at_h-thienel.de>
Date: Fri, 8 Jun 2001 20:50:07 +0200
Message-ID: <9fr6la$6jh$03$1@news.t-online.com>

Since one week we are running Oracle 8.1.7 on VMS-Alpha-Cluster (3 machines) in parallel server mode. VMS Version is 7.2.1. there is one instance of the database on every machine. The database is used by 200-300 users distributed on the 3 machines.

First problem is that Oracle 8 seems to be several times slower than Oracle 7 (maybe 4 times).

But the big problem is that after some hours (1 to 3), Oracle becomes getting slower and slower and then stops processing completely. All users are waiting forever. This seems to be a problem in the lock management (LMD-process). Sometimes this state can be cured by shutting down one instance of the database (then the other two resume working), sometimes all three instances must be shut down and restarted. In a manufacturing environment like ours, these shutdowns are not very wellcome...

We are in contact with Oracle-Support and tweeking around with parameters, but this didn't really help so far.

The situation is escalating - any help is very welcome! Thanks
Harald Received on Fri Jun 08 2001 - 13:50:07 CDT