Only the updates are slow. This did not occur back before we had the
second tier database and before the third tier was upgraded from 8.1.7
to 9.2 (Oracle Financials).
On Behalf Of Ron Rogers
Sent: Wednesday, June 08, 2005 11:28 AM
To: Smith, Ron L.
Subject: RE: Does (block)Size really matter?
Was this ever a "fast" method of inserting data? There are a lot of =3D
factors to consider with the work around you have created. The speed of
=3D the network at the time you are sending the data, the activity on =
=3D different boxes, the activity on the database. How much free memory =
you =3D have in the middle server? If you are sending data through a
dblink I =3D don't think the receiving database does much with it except
use memory or =3D temp space and then passes it on to the next link and
finally to the =3D table.=3D20 That is the method you are doing is't =
is it getting loaded into a =3D table in the middle server and then
If you are not the intended recipient of this e-mail message, any use, =
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received =
this message by mistake, then delete the e-mail message.