If you want to get rid of the content of USER_TAB_MODIFICATIONS or DBA_TAB_MODIFICATIONS then you have to execute dbms_stats.FLUSH_DATABASE_MONITORING_INFO

If that is taking a very long time then you might have hit the oracle bug 5709414

This entry was posted on Thursday, October 30th, 2008 @ 4:53 pm on the category Uncategorized. You can follow any responses to this entry through the RSS 2.0 You can leave a response, or trackback from your own site.