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

From: Guus van de Sande <dyntas.nospam_at_wxs.nl>
Date: 1998/03/23
Message-ID: <01bd5682$315604a0$361279c3@dyntaswxs.nl>#1/1

In addtion to this valuable answer, the following.

On VMS-clusters the distributed lock manager is used by the PSO to check wether rows in the DB are locked by the other node. The Distributed Lock Manager uses a so called master lock-tree on the node that first contacted the database. When this node is not the node on which you are mainly working, you will experience a poor performance.

Solution:
- Shutdown the instances on both nodes, startup the instance on the
'user'-node first and attach this database via

	SQLPLUS making a simple query. 


-	Then startup the instance on the standby node

This forces the Lock-tree to the be mastered by the 'user'-node thus saving a lot of distributed locking which takes about ten times more CPU-power then local locking.

regards,
Guus van de Sande
indepent Oracle Consultant Received on Mon Mar 23 1998 - 00:00:00 CST