Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query performance dramatically different

Re: Query performance dramatically different

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 03 Feb 2006 09:13:19 -0800
Message-ID: <1138986796.602310@jetspin.drizzle.com>


Dusan Bolek wrote:
> There are no database after logon triggers and session parameters are
> exactly the same as is clear from event 10053 output.
> There are no bind variables and everyone is using exactly the same
> query including constant values.
> Actual SQL was not shown because it is accessing a complicated layer of
> views, so showing it would bring no real information
> value.
> Two clients are using 9.2.0.6 client version and one is using 9.2.0.4.
> There is no performance difference between 9.2.0.6
> and 9.2.0.4 in this case.
> Turning the query into a view and executing this view with select *
> from ... (as suggested by Daniel) didn't change the behaviour.
>
> --
> Dusan Bolek

And the ODBC drivers are identical?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Feb 03 2006 - 11:13:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US