RE: Does (block)Size really matter?

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 8 Jun 2005 10:06:01 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA65028A13C7@25exch1.vicorpower.vicr.com>

Probably not.=20

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Wednesday, June 08, 2005 9:17 AM
To: oracle-l_at_freelists.org
Subject: Does (block)Size really matter?

I have a process that sends data through a dblink to an intermediate database and then on to another database. The first database is blocked at 4096, the second is at 8192, the third at 8192. Response is slow (5000 rows in 1.5 hours. Could the difference in block size be a factor?

Thanks!
Ron

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, = =3D
distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received =3D this message by mistake, then delete the e-mail message. Thank you.
--

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

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 08 2005 - 10:11:13 CDT