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

Hi,

There is a view: in fact, table T2 is a view, but it uses the same tables...

And explain plan is the same in the 2 cases!???

Any other idea??

Thanks again!

C.A.

"Billy Verreynne" <vslabs_at_onwe.co.za> a écrit dans le message news: aknh3c$sl$2_at_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:36:04 CDT