Hi Jeff, SReddy, Pando, Tamil, Kishore, Omegamark and others,

I have never implemented OPS environment (though I have read the documentation a little bit)

We are planning to implement it with Oracle 8i (not sure 8.1.5 or 8.1.6) on Sun Solaris

We are evaluating two options for load balancing --
1. Two instances running (on separate nodes) and accessing two different sets of datafiles on two different disk arrays.
The two instances are doing the load balancing and Both the datafile set updating each other as and when there is a change in data.

2. Two instances running (on separate nodes) and accessing the same set of datafiles on one disk array. This will involve the locking issues...what happens when one instance is updating the record that second instance is waiting to read (or update)

I need you opinion about how to implement these types of configuration (what are the pros and cons).
Which is the better way ?

Where can I find some good material on this to read ?

I need to let my boss know today (I am glad he didn't say *yesterday*) which way we are going and why.

Thanks,
- Rajeev