We have 3 oracle instances running on different servers, all servers
have the same O/S configuration and oracle has the same configuration
as well ( I copied over the init's etc from each other) Oracle version
is 8.1.7.4.0 and O/S is solaris 5.8. The databases are all the same we
use distributed databases therefore links to copy data only between
the three oracle servers. Then indexes are done locally on the
database
On server 1 creating indexes takes a average of 35 minutes
On server 2 creating indexes takes a average of 35 minutes then
On server 3 creating indexes takes a average of 55 minutes
The redo logs 10 x 409,600km, I have statspack running and does not
shows any activity at all, I don't even have users there since is a
new configuration for the server in question, I would like to shave
off the extra time if possible, I have different tablespaces for both
indexes and data , all across the file system, I don't know what to do
Thanks
