Analyze Partitions

[marist89]

Let me humbly suggest that YYYYMM would be a superior choice to MMYY

I would doubly humbly suggest that. Also, don't neglect your global statistics, especially after a partition maintenance operation. Personally, I let Oracle figure out what he thinks needs to be analyzed.

http://marist89.blogspot.com/2005/06...sstats_14.html

[stmontgo]

If your partitions are named using something based off of a date or sequence, then you can target your "active" partition as long as the partition name follows a standard naming convention. For example, if you use "some_table_part_MMYY" as the name, then the current month/current partition is ID'd by getting the MMYY part out of sysdate.

yeah but..i recenty did the same thing with a pay calc process in PeopleCrap. to my suprise I saw that the ***arcvhive partition was getting creamed....the proof is the pudding...have a look at segment_stats and file stats to verify