We have an instance data1 on Sun 10000 ( 6 cups, oracle 8.0, 2 tb drives, 4
gig ram) with two development schemas. both have identical tables (same
indexes, constariants, etc). an identical select statement takes 1 minute in
one schema yet 10 minutes in the other. The tables were never more than
couple thounsand rows at any time and no massive deletes were done. Any
reason why a consistant 10 fold diff in speed
one difference is slow schema has been used lot more over last couple of
months while fast one was just created to reflect old one. however, DBAs say
that tables too small for fragmentation to be a problem. Thye mentioned
network problems as possiblity but why would it matter since hte schemas are
on same instance same machine identical tables etc?
Received on Tue Aug 17 1999 - 21:18:22 CDT
