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: Dusan Bolek <spambin_at_seznam.cz>
Date: 3 Feb 2006 06:36:28 -0800
Message-ID: <1138977388.345184.52400@f14g2000cwb.googlegroups.com>


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
Received on Fri Feb 03 2006 - 08:36:28 CST

Original text of this message

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