RE: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <oratips@xxxxxxxxx>
- Date: Wed, 6 Jun 2007 14:54:21 -0400
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:
