Tuesday, 28 July 2009

Performance Tuning - Question 019

A STATSPACK snapshot is a(n) ________ collection of data?

A . dynamic

B. point-in-time

C . ongoing

D . continuously refreshed

Explanation:

Answer B: Each snapshot, executed with the stored procedure STATSPACK.snap, is a point-in-time gathering of cumulative and current statistics in the database. The snapshot is not continuously refreshed, ongoing, or a dynamic collection of data. Each snapshot reads the instance views and populates the PERFSTAT tables with current point-in-time data.

No comments:

Post a Comment