Re: query execution time falls when connected with SYSTEM!!

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Fri, 30 Aug 2002 12:23:25 +0200
Message-ID: <aknh3c$sl$2@ctb-nnrp2.saix.net>

Tuning wrote:

> Oracle Enterprise Edition 8.1.7, HP-UX Server
> optimizer_mode = choose
>
> I've 2 tables: T1 and T2, owned by a user A...
> And a query on these tables which takes about 2 hours to execute
> connected with a user B...
> Then, when connected with SYSTEM, this time falls to 7 seconds!!!

Are these the same tables? Maybe there is a synonym or view in one that uses a different data set or table? Maybe even a synonym to a table on a remote db that is using a distributed join?

It does not make sense that the _same_ SQL on the _same_ tables will result in such a different execution time.

Thus, logic dictates that either the SQL is not the same, or the tables are not the same.

What does explain plan say?

--
Billy

Received on Fri Aug 30 2002 - 05:23:25 CDT