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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bala Sent: Wednesday, June 06, 2007 2:25 PM
To: rjamya_at_gmail.com
Cc: post.ethan_at_gmail.com; 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 -  

--
http://www.freelists.org/webpage/oracle-l