Re: Does (block)Size really matter?

  • From: "Oracle" <all_about_oracle@xxxxxxxxxx>
  • To: <rlsmith@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Jun 2005 12:18:15 +0800

I don't think so, 

Rule #1 Check SQL code first

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

From: "Smith, Ron L." <rlsmith@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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.
> --
> //www.freelists.org/webpage/oracle-l
> 


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

Other related posts: