Re: Performance issue after creating higher block size tablespace

  • From: Saad Khan <saad4u@xxxxxxxxx>
  • To: Martin Klier <usn@xxxxxxxxx>
  • Date: Thu, 25 Feb 2010 11:54:59 -0500

Outch!! No I didnt read it earlier

On Thu, Feb 25, 2010 at 11:45 AM, Martin Klier <usn@xxxxxxxxx> wrote:

> Hi,
>
> Saad Khan schrieb:
> > Is there any other step I can take? I dont want to revert it back to
> > 4k , I think it should work.
> > Any suggestions?
>
> Revert it.
>
> Did you read what Tom Kyte always write about this one?
>
> "BUT - do not use multiple block sizes for anything other than
> transporting data from database A to database B where the block size in
> A is different from B. No silver bullets with this "trick", nothing you
> want to do in real life. The cases whereby multiple blocksizes are
> useful are typically limited to benchmarks, old wives tales, and very
> exceptionally rare conditions."
>
> See here
>
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:729373100346730466
> and here
>
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1468781700346675276
>
> Regards
> Martin
>
> >
>
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> http://www.usn-it.de
>
>

Other related posts: