I use the A) strategy for medium BD's with good
performance behavior, for the fragmentation issue a
good guide is the document:
How to stop fragmentation and start living.
you can find it in metalink..
regards,
Gabriel
- AK <oramagic_at_hotmail.com> wrote:
> At present we have one tablespace containign all
> indexes . Some indexes are big in size some are
> small . Currently tablespace is dict managed. This
> tablespace currently highly fragmented .
> Now I am planning to move the indexes to a LMT. Now
> how to decide what should be the extent size for
> uniform extents ?
> What is better approach to divide indexs
> A ) should I devide them that based on size ( big,
> small ) and create seperate tablespaces with
> different values for extent size .
> b) or seperate them based on modules sooo that
> accounting and manufactring related indexes goes to
> different tablespace.
>
> Does number of extents is a performance issue in LMT
> as well ? Any experience ?
>
> Thanks,
> -ak
>
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Received on Tue Jul 22 2003 - 12:16:28 CDT
