Cheng-Jih Chen wrote:
> Hi, we're developing an application, and have several user logins set
> up for Oracle for testing.
>
> Each of these users are created identically, and have the share the same
> default tablespace and temporary tablespace. They all have the same
> rights, and their schemas are created from the same script. The data
> in these schemas are identical.
>
> However, we're seeing performance differences between two of the users,
> where one user is consistently two or three times faster than the
> other user.
>
> Any suggestions on where to look? I've checked the data segments that
> they own, and these seem to be identical in terms of fragmentation, etc.
> Indexes, and so on, look to be the same, since the schemas were generated
> automatically. I'm not sure where else to look.
>
> Thanks for your help.
>
Did the 'fast' one run dbms_stats.gather_schema_stats to analyze their
tables? Are they both running the same application, so one doesn't have
a better optimized sql statement? Are they requesting the same set of
data ... or is the slow one burdened with retrieving a zillion rows to
the fast one's ten rows? Do both of them use the same network path (same
number of hops between client and db)? You've checked the server side of
the connection ... are they setup identically on the client side? Do
they both have the same sqlnet.ora parameters?
Received on Thu Jan 16 2003 - 17:27:33 CST
