How to identify a stale object
730915Dec 30 2010 — edited Dec 31 2010Hi forum ,
I would like to gather stats on some of my important tables on which DML happens daily (atleast inserts) . So how can I come to know whether the table has stale stats or not. I am thinking the following .
1) Using gather_stale anyways refreshes stale objects , So no need to look for a query which tells stale object or not
2) I can write a query using num_rows from user_tables to find out stale objects .(Here I may miss deletes,updates)
3) I can use alter_tab_modification view , But it flushing the results .
Moreover, I just want to under stand how oracle tells a object stale ? Can we also tell by writing some queries ?
I Appreciate your help.
Mahesh