We are turning off incremental statistics on our partitioned tables - what do I need to do to purge
Oracle 11.2.0.2wri$_optstat_synopsis$ has gotten huge with 224 million rows using 7,880 MB space. I've found enough information out there to convince myself that the incremental stats are just not working as advertised so we are going to turn them off.
What is the best method for cleaning up wri$_optstat_synopsis$? Will turning off the incremental stats do the trick or do I need to do something else?
1