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?
-
LOCK MANAGER
-
STATSPACK
-
ORACLE EXPERT
-
UTLBSTAT /UTLESTAT
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.