Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Who collected stats on a table ?

rahulrasJul 13 2009 — edited Jul 14 2009

Hi All,

I am on Oracle 10.2 on Linux.
We have monitoring enabled on our database (as in case of most of Oracle 10g databases).
Sometimes, some of our procedures gather stats with dbms_stats as well.

How can I find out, for a given table, who has collected the latest stats?
was it Oracle stats collections (which was kicked off as stats is stale)?
or it was dbms_stats called from our code?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2009

Added on Jul 13 2009

#general-database-discussions

7 comments

788 views