Re: Urgent: Oracle 8 parallel server on VMS 7

Hi,
 I think it is not the problem with OPS Oracle, it is depending up on the database architecture. slow because of the LMD. may be you have to change your archi. what kind of system you were running.

Thanks
"Harald Thienel" <harald_at_h-thienel.de> wrote in message news:<9fr6la$6jh$03$1_at_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 - 15:46:20 CDT