Which version of Oracle are you using. In 8i you can
set 'monitoring on' for the tables and use dbms_stats to analyze stale. (Though,
I am getting error while using dbms_stats for the partitioned tables. So I have
made a home made version to analyze stale). As per my calculations, package
dbms_stats considers statistics stale if all DMLs affect more than 10%
of number of rows.
Anand Prakash
>>> dbrowett_at_city.coquitlam.bc.ca 10/23/01 11:00AM
>>>We have a data-warehouse that is a combination of Snapshots and
table-buildsbased on the snapshots.The table builds run at 4:30 am,
scripts are setup to start the snapshots at7:00am and end at
9:00pm. At 6:30 am a script performs an analyze on ALL (except sys
andsystem) tables inthe database.If the snapshots have been
running all day, should I run an analyze before Ido the table builds?as
opposed to after ?At what point do the statistics on a table become no
good ? when a new rowis added
?ThanksDarren--------------------------------------------------------------------------------------------------------------------------Darren
Browett P.Eng
This messagewas
transmittedSystems Analyst - Information Systems
using 100%recycled
electrons City of Coquitlam P:(604)927 - 3614
E:dbrowett_at_city.coquitlam.bc.ca
- Please see the official ORACLE-L FAQ: <A
href="">http://www.orafaq.com-- Author:
Browett, Darren INET: dbrowett_at_city.coquitlam.bc.caFat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Tue Oct 23 2001 - 16:57:54 CDT
