RE: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

Bala,

 

Is your table being monitored?

 

Alter table {table_name} monitoring

 

Tom

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bala
Sent: Wednesday, June 06, 2007 2:25 PM
To: rjamya@xxxxxxxxx
Cc: post.ethan@xxxxxxxxx; oracle-l
Subject: Re: Trigger SMON to dump table statistics to
ALL_TAB_MODIFICATIONS

 

If we insert/delete/update/truncate a table and than do 

step 1) exec dbms_stats.flush_database_monitoring_info

 

step 2) select * from all_tab_modifications

 

zero rows returned ? since we are "flushing" the monitoring info ?

 

Thanks in advance

bala -

 

Other related posts: