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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER