Re: LOCAL vs DICTIONARY managed tablespaces
Date: Thu, 30 May 2002 01:26:47 GMT
Message-ID: <ndfJ8.144690$Po6.311859_at_rwcrnsc52.ops.asp.att.net>
Use locally managed tablespaces of uniform size(uniform within a
tablespace - you can make the uniform size larger than 1m eg 10m). LMT will
perform better.(all else being equal) You can use temp file for temporary
tablespaces.
Jim
"Vissu" <Vissuyk_at_yahoo.com> wrote in message
news:16b21687.0205291610.777f2931_at_posting.google.com...
> We are moving to 92 RDBMS from an older version which did not have the
> concept of locally managed tablespaces.
>
> When should I use LOCAL vs DICTIONARY managed ? The 9i docs seem to
> suggest using LOCAL for temporary tablespaces. What about permanent
> ones ? One drawback I think with LOCAL is the fact that the extent
> size is fixed if UNIFORM and defaulst to 1M which is small. Iwant to
> use UNIFORM size to minimize fragmentation.
>
> Which tablespace will perform better under peak loads ? We have about
> 500+ users querying the database at peak times. DMLs do not occur at
> peak times.
> Th emain table has 10 millions records and growing fast.
>
> Any suggestions are appreciated
>
> Thanks
>
> Vissu
Received on Thu May 30 2002 - 03:26:47 CEST