Re: Unlimited extents?

If you want to use unlimited extents, then I suggest doing this in a locally managed tablespace if at all possible. While an extremely high number of extents does not hamper application performance for *most* cases, it can hamper performance if a segment is dropped. The recursive SQL to SYS.UET$ can cause some performance problems in these cases. LMT's remove UET$ from the equation.

HTH,
Brian

"news1.trim.net" wrote:
>
> What is the general feeling towards setting table and tablespace storage
> settings to unlimited extents. My tendency is to want to set the extents as
> close as possible to what I have calculated as being enough. Am I being
> foolish? Should I just let it go?
>
> What are the pros/cons?
>
> Thanks
>
> Barry
Received on Mon Dec 10 2001 - 15:52:58 CST