Oracle Database Discussions

Hi All,

I know this question has been asked many times but there is a brand new problem that I am facing.

We pre-create the parititions for one month for some of the tables. But the issue is that when we gather stats, even after specifiying partition name, it even gather stats for the empty parititions too. And it takes a lot of time to gathers stats for those empty partitions. Not sure why this happens.

I am not against of gathering stats for empty partitions but why does it take a lot of time to gather stats for them.

This process in-turn is taking a lot of time to complete.

Any ideas how to stop this?

Regards,
Ishan