Re: Performance different between two users

Check against v$sessionwait and look at P1, P2, P3. These columns will give you hints on which latch the user is waiting.

Reid

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.
>
>
Received on Sun Jan 19 2003 - 10:21:48 CST