Dusan Bolek wrote:
> Hello,
>
> I have encountered a weird problem last week and been dealing with it
> since. I have a query that is accessing several tables in remote
> Teradata databases using Oracle OpenGateway( formerly known as
> Transparent GW). The problem is that the same query is finishing either
> in 30 seconds or in 30 minutes with this pattern:
>
> 1) if executed from sqlplus on my computer (9.2.0.6 client) - 30s
> 2) executed from my colleague's computer (9.2.0.1 client) - 30 minutes
> 3) executed from another colleague's computer (9.2.0.6 client) - 30
> minutes
> 4) executed using JDBC on all computers including mine - 30 minutes
Assuming the above is repeatable take a good look the drivers on the
client machines. Are they the same version? What happens if the query
is written as a view and the only thing passed to Oracle is SELECT *
FROM?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Feb 02 2006 - 14:04:46 CST
