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

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: 29 May 2006 05:38:18 -0700
Message-ID: <1148906298.513352.188100@j33g2000cwa.googlegroups.com>

Jonathan,

I've finally come around to testing your suggestion. Loading the table now took 54 minutes, as opposed to 32 minutes in case of reading over the link, but there were other processes busy executing this time. The wait event distribution looks as follows:

log file switch completion
number: 46
time waited: 2.89 s

free buffer waits
number: 254
time waited: 13.64 s

db file sequential read (a tracked the p1/p2 values for some, the target table was read!)
number: 9872
time waited: 28.57 s

db file scattered read
number: 7827
time waited: 111.33 s

CPU used by this session
total time: 1841.19 s (value when reading over the link:1496.86 s)

Reading the target table now takes 111 seconds. This used to be 57 seconds, possibly due to the other processes running?

As you predicted, CPU increases. Would this mean that enlarging the SDU could decrease the CPU consumption for reading the remote table?

Jaap. Received on Mon May 29 2006 - 07:38:18 CDT