Re: Locally Managed Tablespaces - any cons???

Ron Gardiner wrote:
>
> New for 8i (I believe) is locally managed tablespaces...
>
> From what I've read, sounds like there is no reason NOT to use them. Can
> they be used for all types of TS?... rollback segs, temporary, how about
> system itself?
>
> Any feedback would be appreciated!

None I can think of - but be aware that queries on dba_segments and/or dba_extents will be more expensive because they need to read the bitmaps on each file...So don't go too hard on them.

hth

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."