Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_STATS and Table Monitoring

DBMS_STATS and Table Monitoring

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Thu, 18 May 2000 15:48:46 -0700
Message-Id: <10501.106027@fatcity.com> 





Has anyone altered their tables to set the "monitoring" attribute in orderto
use dbms_stats to gather "stale" statistics.  If so how large is your
database, how many tables are being monitored, and have you seen any impact
from the monitoring?



Ian MacGregor


Stanford Linear Accelerator Center


ian_at_slac.stanford.edu
Received on Thu May 18 2000 - 17:48:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US