469,903 Members | 2,196 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

Index creation too long

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
Maria
Jul 19 '05 #1
1 3551
ev******@yahoo.ca (Maria) wrote in message news:<35**************************@posting.google. com>...
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
Maria


1- Compare object size and make sure the problem instance does not
have bigger objects

2- Compare the definitions of the temporary tablespaces and
sort_area_size

3- Take a look at the physical disk to logical file layout.

Good luck
-- Mark D Powell --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by SK | last post: by
11 posts views Thread by dfurtney | last post: by
14 posts views Thread by Sean C. | last post: by
1 post views Thread by chettiar | last post: by
10 posts views Thread by Laurence | last post: by
5 posts views Thread by vd12005 | last post: by
reply views Thread by Spacen Jasset | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.