32K block size tablespace for indexes
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Jan 2009 07:03:41 +0000 (GMT)
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-l
- Follow-Ups:
- Re: 32K block size tablespace for indexes
- From: Niall Litchfield
- Re: 32K block size tablespace for indexes
- From: Jared Still
- Re: 32K block size tablespace for indexes
- From: Andy Rivenes
- Re: 32K block size tablespace for indexes
Other related posts:
- » 32K block size tablespace for indexes - hrishy
- » Re: 32K block size tablespace for indexes - Niall Litchfield
- » Re: 32K block size tablespace for indexes - hrishy
- » Re: 32K block size tablespace for indexes - Guillermo Alan Bort
- » RE: 32K block size tablespace for indexes - Yavor Ivanov
- » Re: 32K block size tablespace for indexes - Jared Still
- » Re: 32K block size tablespace for indexes - Andy Rivenes
- » Re: 32K block size tablespace for indexes - Greg Rahn