Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query performance dramatically different
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