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

Hi Tuning,

Same tables, same queries, same execution plans, one is 2 hours, the other 7 secs ?

I think we might need some proof of this.

The things I can think off the top of my head are:

1. One of the above is not true
2. One session has a tiny *area_size, the other a massive one.
3. You're using Resource Manager and both users are in different consumer groups (in one seriously busy environment)
4. One of the users is in serious need of a new watch ;)

Cheers

Richard
"Tuning" <c_armanet_at_hotmail.com> wrote in message news:aknhog$k48$1_at_wanadoo.fr...
> 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 - 07:10:23 CDT