RE: Does (block)Size really matter?

The process reads and writes data to tables in the third tier database. 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).

Thanks!
Ron

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ron Rogers Sent: Wednesday, June 08, 2005 11:28 AM
To: Smith, Ron L.
Cc: oracle-l_at_freelists.org
Subject: RE: Does (block)Size really matter?

Ron.
 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 =
the
=3D different boxes, the activity on the database. How much free memory =
do
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 = it. Or
is it getting loaded into a =3D table in the middle server and then select...insert._at_last server?

Ron

--
http://www.freelists.org/webpage/oracle-l


Important Notice!!
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.
Thank you.
--
http://www.freelists.org/webpage/oracle-l