32K block size tablespace for indexes
From: hrishy <hrishys_at_yahoo.co.uk>
Date: Thu, 29 Jan 2009 07:03:41 +0000 (GMT)
Message-ID: <585464.69753.qm_at_web27403.mail.ukl.yahoo.com>
Hi
Date: Thu, 29 Jan 2009 07:03:41 +0000 (GMT)
Message-ID: <585464.69753.qm_at_web27403.mail.ukl.yahoo.com>
Hi
I have inherited a database where the indexes alone are in the 32k block tablespaces.
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 ?
regards
Hrishy
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 29 2009 - 01:03:41 CST