Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query performance dramatically different
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 BolekReceived on Fri Feb 03 2006 - 08:36:28 CST