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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 May 2006 22:06:09 +0100
Message-ID: <ge2dnZKOEZMiuu_ZRVnyuw@bt.com>

"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'.
.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

Received on Mon May 22 2006 - 16:06:09 CDT