Indeed. One can argue about the 10% threshold that the monitoring
facility is using to trigger a re-analyze, but it's so much easier to
set this up now. Should be mandatory for everybody :).
Mogens
John Kanagaraj wrote:
Arslan,
Since you are on 8.1.7, have you considered using the ALTER
Title: Frequency of Analyze
It is due to your data change. Ifsmall number
of of data change occurs you may need to do itmonthly . But
I have read somewhere that Analyze is recommended
for every week for oltp databases.
Bunyamin
- Original Message -
From:
Arslan
Dar
Can't say about recommended, but we analyze most of our tables weekly
(during a slow time on Sunday) and the two tables that have lots of delete
and insert activity and often vary widely in size from day to day are
analyzed daily.
-Original Message-
Sent: Friday, February 15, 2002 10:23
I analyze weekly as well as rebuilding index weekly on 8.1.7.2 on HP.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/15/02 8:23 AM
Can't say about recommended, but we analyze most of our tables weekly
(during a slow time on Sunday) and the two tables that have
Arslan - Yes, I agree with Bunyamin. I perform weekly analyzes on my OLTP
databases. This allows me to create a history of table growth for capacity
projections. I have found a weekly measure of table rows is a reasonable
balance between the ability to catch unexpected events and the effort
Arslan,
Since you are on 8.1.7, have you considered using the ALTER TABLE ...
MONITORING feature? This will create entries in DBA_TAB_MODIFICATIONS
detailing the estimated DML on the tables involved along with a Timestamp.
This will enable you to estimate the required frequency...
John
