stale or empty statiscs [message #410381] |
Fri, 26 June 2009 14:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hi Experts,
I have one basic question:-
How can we know if the statiscs on a table are stale or empty.
Regards,
Varun Punj
|
|
|
|
|
Re: stale or empty statiscs [message #410384 is a reply to message #410381] |
Fri, 26 June 2009 14:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
We can find stale statisics from the following query:-
SELECT * FROM DBA_TAB_STATISTICS WHERE STALE_STATS='YES';
Please tell me how to find information about empty statistics.
Regards,
Varun Punj
|
|
|
|
|