LMT Migration

From: AK <oramagic_at_hotmail.com>
Date: Tue, 22 Jul 2003 08:53:45 -0700
Message-Id: <25988.338909@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0348_01C3502E.C2640B80 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 ?=20 What is better approach to divide indexs=20 A ) should I devide them that based on size ( big, small ) and create = seperate tablespaces with different values for extent size .=20 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

------=_NextPart_000_0348_01C3502E.C2640B80 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>At present we have one tablespace =
containign all=20
indexes . Some indexes are big  in size some are small . = Currently=20
tablespace is dict managed. This tablespace currently highly fragmented=20 .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Now I am planning to move the indexes =
to a LMT. Now=20
how to decide what should be the extent size for uniform extents ? =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>What is better approach to divide=20
indexs </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>A ) </FONT><FONT face=3DArial =
size=3D2> should I=20
devide them that based on size ( big, small ) and create seperate = tablespaces=20
with different values for extent size . </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>b)    or seperate =
them based on=20
modules sooo that accounting and manufactring related indexes goes to = different=20
tablespace.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Does number of extents is a performance =
issue in=20
LMT as well ? Any experience ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>-ak</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
Received on Tue Jul 22 2003 - 10:53:45 CDT