Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance difference between 2 machines
Etunimi Sukunimi <etunimi.sukunimi_at_sonera.com> wrote:
> sybrandb_at_yahoo.com wrote:
> > The obvious cause is the difference in database block size.
> > Ct shouldn't have set it to 16k. Means one physical I/O executed by
> > Oracle, will result in *2* physical I/Os on O/S level. Those two I/Os
> > will suffer from rotational delay by the disks (ie, the second 16K will
> > be read not immediately after the first).
> > IMO, setting the database block size bigger than the O/S block size
> > will result in massive delays... which is what we are seeing here.
> >
> >
> > Hth
> > ---
> > Sybrand Bakker
> > Senior Oracle DBA
> >
>
> Dang!
>
> I wonder why the dba didn't know this...
>
> Thanks!
>
> The only way to rectify this is to a full export - create a new database
> - full import, right?
Can you let us know how it turns out?
Thanks,
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Mon Jun 20 2005 - 12:34:47 CDT