What is DBMS_STATS package?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is DBMS_STATS package?
Rating:
The DBMS_STATS package is used for viewing and modifying performance statistics against database objects such as tables, indexes etc. The performance statistics generally reside in the data dictionary. However, the performance statistics can be copied to the local tables and can be effectively used without affecting the performance of the optimizer.
Rating:
Was this information helpful?
Other articles
- What is a cluster ?
- What is ASMB?
- What is conventional path Export?
- What are the different types of data loading methods used by SQL*Loader?
- What is a listener.ora file?
