RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Database Monitoring
«Prev
Next»
DBA Taks
Database Monitoring
Control File Parameters
Protecting Control Files
Removing Control File
Add Control File
Backingup Control File
Recreating Control Files
Checking Parameter Values
v Parameter Dynamic
Changing DB Parameters
Managing DB Parameters
Managing Redo Log
Protecting redoLog Files
Listing RedoLog Files
Create Redo Log Files
Dropping Redo Log Files
Moving Redo Log Files
Manually Switch Log Files
Managing RedoLog Conclusion
Redolog Files
Archivelog Mode
Archive Log Destination
Naming Archive Log Files
Manually Archiving Log File
Archive Log History
Archivelog Mode Conclusion
Manage Tablespace Files
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.
Background/overview
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.
Instructions
Find the utlbstat.sql and utlestat.sql files on your system.
Make them your default directory.
Run SQL*Plus
Connect as INTERNAL, and execute the utlbstat.sql script.
Wait a few minutes, and then execute the utlestat.sql script.
Exit SQL*Plus and review the resulting report.txt file.
Submitting your exercise
This is an auto-scored exercise. When you are done, paste your work in the textbox and click the
Submit
Button to receive full credit.