Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why would 2 schemas in same instance with identical tables and data display 10 fold diff in speed
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