Re: Performance issue after creating higher block size tablespace
Date: Thu, 25 Feb 2010 17:45:24 +0100
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?
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."
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 25 2010 - 10:45:24 CST