From: Connor McDonald Newsgroups: comp.databases.oracle.server Subject: Re: Locally Managed Tablespaces - any cons??? Date: Wed, 08 Aug 2001 18:49:14 +0100 Organization: OWDS Inc. Lines: 22 Message-ID: <3B717B9A.557C@yahoo.com> References: Reply-To: connor_mcdonald@yahoo.com NNTP-Posting-Host: 62.172.35.218 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.chatlink.com 997292977 2979 62.172.35.218 (8 Aug 2001 17:49:37 GMT) X-Complaints-To: abuse@chatlink.com NNTP-Posting-Date: Wed, 8 Aug 2001 17:49:37 +0000 (UTC) X-Mailer: Mozilla 3.01 (WinNT; I) 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..."