Re: How do I speed up processing the data from a database link?

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Tue, 23 May 2006 13:25:51 GMT
Message-ID: <z3Ecg.7894$Ar6.4014@trnddc02>

Jonathan Lewis wrote:
> "Chuck" <skilover_nospam_at_bluebottle.com> wrote in message
> news:Kspcg.54030$ge7.3582_at_trnddc01...

>> "SQL*Net more data from dblink" is an idle wait event, similar to
>> "SQL*Net more data from client". It's just the source of the data that's
>> different.
>>
>> To speed it up, you could try tuning the query. If you post it here we
>> might be able to help more. Please post the explain plan for the query
>> as well.

>
>
> No, "MORE data from" is not an idle wait, it is
> a wait that means a large data chunk has to come
> in packets from the client, and therefore is an
> indication of a possible network "waiting for traffic"
> issue - the turnaround time should be 'machine speed',
> not 'human think time'.
> .
>
>

I guess it depends on what you consider an idle wait event to be. The DB instance is idle during "MORE data from..." and is not consuming CPU. As far as the instance (or more correctly the session) is concerned, it's waiting on an asynchronous network event. But that doesn't mean there's nothing that can be improved here. Both the network and remote query are still in play. That's why I asked to see the query and the explain plan.

Chuck Received on Tue May 23 2006 - 08:25:51 CDT