The ANALYZE command is more versatile and potentially faster than using the DBMS_STATS package to generate statistics.
Correct Answer:
Verified
Q14: The DBMS_STATS package can be used to
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
Q20: The ANALYZE command is complex and hard
Q21: You can use the V$ performance views
Q22: _ statistics parameters generate system statistics essential
Q23: _ is a set of scripts used
Q24: _ is simply a formatting tool used
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