Xref: alice comp.databases.oracle.server:42169 Path: alice!news-feed.fnsi.net!newsfeed.wli.net!su-news-hub1.bbnplanet.com!su-news-feed1.bbnplanet.com!news.gtei.net!inet16.us.oracle.com!not-for-mail From: Peter Sharman Newsgroups: comp.databases.oracle.server Subject: Re: Oracle Statistics Date: Wed, 03 Mar 1999 16:36:30 -0800 Organization: Oracle Corporation Lines: 37 Message-ID: <36DDD58E.3F1778AD@us.oracle.com> References: <7bkk3k$p7f$1@news.monmouth.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.5 [en] (WinNT; U) X-Accept-Language: en Roman A somewhat dated definition now that there are some huge tables out there, but a full table scan increments this value if the table is > 5 blocks. If it's < 5 blocks, it increments the short tables value instead. HTH Pete Roman Gelfand wrote: > Does anyone know what is the definition of long table on v$sysstat's full > table scans (long table) statistic? > > Thanks in advance -- Regards Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Peter Sharman Email: psharman@us.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local) San Francisco "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~