Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone2.usenetserver.com!c03.atl99!news.webusenet.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!peernews3.colt.net!newsfeed.stueberl.de!newsfeed01.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail
From: Rick Denoire <100.17706@germanynet.de>
Newsgroups: comp.databases.oracle.server
Subject: Monitoring automatic analysis of stale tables
Date: Fri, 04 Apr 2003 23:53:48 +0200
Organization: T-Online
Lines: 18
Message-ID: <g7vr8v4p5385np7nj0fni61hkkolll05m8@4ax.com>
Reply-To: 100.17706@germanynet.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.t-online.com 1049493195 02 9549 WOLxE1FTS-YsIQ 030404 21:53:15
X-Complaints-To: abuse@t-online.com
X-ID: Ghp7zgZTZe0ZadzpsufwgUklzipKF2XjMMiQ5WqkF-FLHjzvRDGL8p
X-Newsreader: Forte Agent 1.7/32.534
Xref: newsfeed1.easynews.com comp.databases.oracle.server:182059
X-Received-Date: Fri, 04 Apr 2003 14:54:49 MST (news.easynews.com)

Hello

I have set the monitoring option of the tables in an Oracle DB (8.1.7)
and I can see how Oracle tracks changes glancing at the
DBA_TAB_MODIFICATIONS. But how do I see which tables are actually
analyzed by Oracle when the routine dbms_stats.gather_schema_stats is
used for stale tables? And how can I use this routine to analyze stale
indexes as well?

I have put a script as a cron job that runs every 4 hours looking at
stale tables and tables with empty statistics to be analyzed. I am
only afraid that if the analysis of a large table takes longer than 4
hours, Oracle would decide to analyze it again while it is being still
analyzed...

Thanks for your comments

Rick Denoire