Re: Urgent: Oracle 8 parallel server on VMS 7

Personally, if I were going to run an Oracle database on OpenVMS it would not be Oracle Classic, but Oracle Rdb. Rdb has been running on muliptle nodes in a true cluster very successfully for many years now. (For those in the comp.database.oracle.server newsgroup, Digital and OpenVMS invented the cluster, not as some of you have been told that it was Sun or NT and has been around since '81-'82 timeframe) While OPS on VMS has also been around a while, Rdb seems to have done it right and it just works.

Michael Austin
DBA Consultant (Oracle Rdb and Oracle "Classic" on OpenVMS and most popular flavours of Eunichs)

chan01 wrote:

> 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 Sun Jun 10 2001 - 12:38:41 CDT