Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Does (block)Size really matter?
I don't think so,
Rule #1 Check SQL code first
From: "Smith, Ron L." <rlsmith_at_kmg.com>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, June 08, 2005 9:17 PM
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, =
> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 09 2005 - 00:22:39 CDT
![]() |
![]() |