Multiple choice

JOHN has been taking snapshots once a week over the last two years. He will use these snapshots to outline the cost associated with the increase in database resources over the past two years. Which tool or utility would allow him to compare the snapshots?

  1. LOCK MANAGER

  2. STATSPACK

  3. ORACLE EXPERT

  4. UTLBSTAT /UTLESTAT

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

STATSPACK is the correct tool for comparing snapshots over time. It captures database performance statistics at intervals and provides reports to compare different snapshots. LOCK MANAGER handles locking, ORACLE EXPERT is for tuning recommendations, and UTLBSTAT/UTLESTAT are older tools replaced by STATSPACK.