There are some non-optimizer statistics that can only be gathered with the DBMS_STATS package and not with the ANALYZE command.
Correct Answer:
Verified
Q8: The DBMS_STATS package can be used to
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
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
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