two users differ in perf. for same query

From: <chrisoc_at_ans.net>
Date: Wed, 10 Jun 1998 17:52:44 GMT
Message-ID: <6lmh5c$2a8$1@nnrp1.dejanews.com>

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 Wed Jun 10 1998 - 12:52:44 CDT