Link to home
Start Free TrialLog in
Avatar of GP7
GP7

asked on

How to see if there are statistics available on an object in oracle database?

Hi All,

How to see if there are statistics available on an object in oracle database? If they are available, how do  know if they are stale or not. Are there any views to get this information?

Could anybody please also let me know if there is a view to see if an index is unselective or not. I mean I would like to see how often the index is being used.

Your input is greatly appreciated.

Thank you.

ASKER CERTIFIED SOLUTION
Avatar of jocave
jocave
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Naveen Kumar
Naveen Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GP7
GP7

ASKER

Thank you all for your input. I shall implement your recommendations and shall get back to you soon.

I believe we ( jocave and myself ) have given the information which should have detinitely helped GP7.
I believe we ( jocave and myself ) have given the information which should have definitely helped GP7.
All,
 
Following an 'Objection' by nav_kum_v (at https://www.experts-exchange.com/questions/26700482/Automated-Request-for-Review-Objection-to-Delete-Q-26598493.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
SouthMod
Community Support Moderator