Xref: alice comp.databases.oracle.server:74694 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.icl.net!diablo.theplanet.net!diablo2!news.theplanet.net!newspost.theplanet.net!not-for-mail From: Connor McDonald Newsgroups: comp.databases.oracle.server Subject: Re: Number of Extents on SYS tables Date: Thu, 18 Nov 1999 18:59:38 +0800 Organization: Customer of Planet Online Lines: 21 Message-ID: <3833DC1A.6306@yahoo.com> References: <3832e746.253472744@client.nw.news.psi.net> Reply-To: connor_mcdonald@yahoo.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news5.svr.pol.co.uk 942951217 24818 62.136.199.57 (18 Nov 1999 18:53:37 GMT) NNTP-Posting-Date: 18 Nov 1999 18:53:37 GMT X-Complaints-To: abuse@theplanet.net X-Mailer: Mozilla 3.01 (Win95; I) To: Chuck Chuck wrote: > > Is it healthy to have tables owned by SYS with upwards of 75 extents? > I have a handfull (like 15 - 20) tables with 75 or more extents. > > Thanks,a > Chuck Assuming they are legitimately SYS tables, then it is not a drastic problem since SYS uses the rule optimiser but you can avoid these problems in future by taking an (informed) look at SQL.BSQ before creating your database. HTH -- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald@yahoo.com "Some days you're the pigeon, and some days you're the statue."