Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Does (block)Size really matter?

Re: Does (block)Size really matter?

From: Oracle <all_about_oracle_at_hotpop.com>
Date: Thu, 9 Jun 2005 12:18:15 +0800
Message-ID: <005b01c56caa$44d11380$0200a8c0@ncs.corp.intads>


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-l
Received on Thu Jun 09 2005 - 00:22:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US