Database Monitoring   «Prev  Next»

Collecting statistics - Exercise

Objective: Use utlbstat and utlestat to generate statistics for the COIN database.

Exercise Scoring

This is an auto-scored exercise worth 20 points.


You are a new DBA, and you've decided to try running the utlbstat and utlestat scripts just to see what the resulting report looks like.


Find the utlbstat.sql and utlestat.sql files on your system. Make them your default directory. Run Server Manager, connect as INTERNAL, and execute the utlbstat.sql script. Wait a few minutes, and then execute the utlestat.sql script. Exit Server Manager and review the resulting report.txt file.

Submitting your exercise

This is an auto-scored exercise. When you are done, click the Submit Button to receive full credit.