Re: two users differ in perf. for same query

From: Merle Martell <martell_merle/hdqt_at_hdqt.cargill.com>
Date: Thu, 11 Jun 1998 15:39:59 -0500
Message-ID: <3580409F.5C1E07C8@hdqt.cargill.com>

Try running with the fast userid on the slow users client. This will tell you if it is a client or network problem or if it is something in the databse. Let me know what happens.

merle_martell_at_cargill.com

chrisoc_at_ans.net wrote:

> One user has granted select on all his tables to the other. The
> real owner has 10x faster performance on a complex join, than does
> the grantee. Both have the same TEMP tablespace ( I mean really
> the same!) and same ARRAYSIZE, MAXDATA in their sqlplus environment.
> It's the same machine and disk layout for both.
> Does this ring a bell with anybody?
>
> Chris O'Connor
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Jun 11 1998 - 15:39:59 CDT