Re: Urgent: Oracle 8 parallel server on VMS 7

Hi,

thanks for your response! The architecture of the database or the applications did not change vom Oracle Version 7, where it run very satisfying
What can we change to make the system run better?

Regards
Harald

"chan01" <chandra_2000_us_at_yahoo.com> schrieb im Newsbeitrag news:480cb9d4.0106081246.5320fecb_at_posting.google.com...
> 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 Sat Jun 09 2001 - 11:33:50 CDT