The DBMS_STATS package can be used to gather statistics at all object layers of an Oracle database,such as for tables,indexes,even for a whole schema or an entire database.
Correct Answer:
Verified
Q9: To monitor the performance of an Oracle
Q10: The STATSPACK is the recommended tool for
Q11: There are operating system tools that provide
Q12: Performance monitoring is most easily performed with
Q13: There are some non-optimizer statistics that can
Q15: Oracle recommends not using the Database Control
Q16: You can manually gather statistics for snapshot
Q17: That metadata and statistical record of an
Q18: Autotrace can be enabled using the SET
Q19: The ANALYZE command is more versatile and
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents