Re: 32K block size tablespace for indexes
Date: Thu, 29 Jan 2009 07:51:27 +0000
most likely because they read some advice on it. Note I have an opinion on this, but this might help with the background
related papers and blogs)
There's been a whole host of, somewhat heated, discussions on this lately on otn.
On Thu, Jan 29, 2009 at 7:03 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:
> I have inherited a database where the indexes alone are in the 32k block
> Now without any documentation or anything for a hint i am just wundering
> why did the original designers design it like that?
> What are the pro's and cons of such a approach ?
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 29 2009 - 01:51:27 CST