Re: Query with dblink runs slow

From: jim mcnamara <jmcnamar_at_swcp.com>
Date: 1 Aug 2002 09:44:52 -0700
Message-ID: <19b60539.0208010844.4ef5737@posting.google.com>

SET ARRAYSIZE 200 improves performance over a dblink. What it does is fill the prefetch queue with 200 rows rather than the default of 15. Going beyond 200 does not have any quantifiable result, IMO.

This will NOT take your query time down to nine seconds. Maybe 30 seconds vs two minutes.

jim mcnamara

bill__wong_at_hotmail.com (Bill Wong) wrote in message news:<5fb59d0f.0207251343.5257792c_at_posting.google.com>...
> I have a query that retrieves data from a secondary database (TEST2)
> via a dblink from the primary database (TEST1) at which I logged in.
> It took 2+ minutes to run.
>
> I copied the query, removing the dblinks and ran it in TEST2. It took
> only 9 seconds.
>
> Any suggestions?
Received on Thu Aug 01 2002 - 11:44:52 CDT