Re: Performance different between two users

On Thu, 16 Jan 2003 19:21:38 -0000, postmaster_at_cjc.org (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.

Your users will both parse the same statements, as different schemas are considered, and likely they will both push each others data out of the buffer cache.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 16 2003 - 13:41:21 CST