Sanjay Mishra wrote,on my timestamp of 19/11/2009 2:37 PM:
One example is that if there monthly partition table containing several Gig data and when new partition created and utiliZed can experience some performance slowness on the first day of the month. and so
The approach I take is: The application knows when to calculate stats. Not the database.As such, if the creation of the new partition is a monthly maintenance job/script/package/procedure, then add the stats calculation to the end of it.
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l