Re: 7.0 Oracle Parallel Server Option on VMS 5.5 ???

On Thu, 19 Mar 1998 17:00:12 -0800, Glen Shortliffe <glenner_at_cyberdude.com> wrote:

thank you all for the help. it will greatly aid our effort in correcting this problem. Some of you have asked for feedback w.r.t your suggestions. I will do this as soon as it is possible to implement them. (There is no "development environment" to speak of here ... we are tuning a live system which cannot be brought down at whim ... as soon as we can schedule some down time, i will let you know)

thank's again

tonys.
>yes that's right!!
>
>we are running with the above configuration. at this point any type of
>upgrade does not seem plausible.
>
>situation:
> 2 machines (one designated primary, the other backup)
> the backup machine does essentially nothing
> -- it has the database instance up (with PSO) just for fast
>recovery of primary fail
> -- 8 applications are connected to this database, but they do
>absolutely nothing until
> a primary failover occurs.
> the primary machine does everything, runs all applications.
>
> to boost performance it was though to really implement the PSO by
>load sharing, i.e.
> running some applications on the backup.
>
> application was a fairly large import (70K rows, 7 8-char columns, 2
>4-column indexes).
> during the time of the import, the table in question was not being
>accessed (neither
> queries, nor updates) by any other application on either machine.
>
> however, the performance on the primary machine due to the import on
>the backup was
> severely hindered. does anybody know why? is this tunable?
> how do parallel servers communicate on VMS??
>
>if responding .. please ignore email address in the reply, instead
>
>mailto:karkalis_at_earthling.net
>
>o/w please post an answer!!!
>
>thanks,
>
>tonys.
>
Received on Thu Mar 26 1998 - 00:00:00 CST