Check if one is analyzed and the other is not
UB
ramdan <ramdan_at_mailexcite.com> wrote in message
news:pJou3.524$Ce7.26024_at_newscene.newscene.com...
> 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 Wed Aug 18 1999 - 21:56:41 CDT
