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

I have got some knowledge on OPS and a couple of things could be happening here:
1) the import does an insert into a table and index, the file(s) that these objects

    reside in can have objects that are being accessed by the other instance. You

    get what is called False Pinging. Now two situations are possible:

1. you don't have gc_files_to_locks set at all (easy just set it and assign some locks to each file)
2. you have gc_files-to_locks set, but didn't apply enough locks.
3. False pining on the segment header of objects -> increase gc_segments (default is 20, to some larger value).

Now if you would show me an output from v$system_event, while this is happening I can tell you some more about this.

Anjo Kolk.

I work for oracle, but I speak for myself ....

Glen Shortliffe wrote:

> 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 Tue Mar 24 1998 - 00:00:00 CST