Re: Performance issue after creating higher block size tablespace

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

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