Re: Problem with ORACLE Parallel Server

: I have installed ORACLE Parallelserver (8.0.5 with about 20 patches) on VMS
: (V7.2-1). There are two machines in the VMS-Cluster. If I start only one
: instance, ORACLE is running with more or less good performance. If I start
: the second instance on the other machine, the database hangs every few
: minutes for a while. Hangs mean I can't access the Database even with

I have the same problem on our OpenVMS two node cluster running Oracle 7.3. Aproximatly every 10 minutes db stoped working for 30 seconds. No memory usage, no CPU usage and very small IO activity appear.

After many days of testing and watching db we found that stopped db correspond to high deltas of cross instance CR read in v$sysstat.

Solution was simple. Our system implements its own load balancing of batch job load. Every 10 minutes were all jobs switched into other instance and this was the cause of problem. After removing switching batch jobs between instances db is OK.

        Starous Received on Wed Aug 09 2000 - 00:00:00 CDT