Entire playback

This option plays back data for all input recording sessions summarized as a single sample. For example, seven input recording sessions would result in a single playback sample. The sample interval is the timespan between the requested playback start_time and end_time.

The playback view can use statistic types different from those in the recorded data, and it can include some estimated and calculated data items not in the original view. It cannot include snapshot data, such as process or lock status data and current SQL statement data. See Table C-2 for a definitive list of data items that can be converted or added to a playback view.

Choose this option to consolidate recorded data, rolling up details into overviews of activity over longer time periods.

If the requested playback start or end times fall in the middle of the input recording session, Historical Server prorates counted values and performs weighted averages on percentages and rates. The weights are the number of seconds that each input sample contributes.

For example, if the playback session start_time is 3 p.m. and the end_time is 6 p.m., and an input recording session started at 1 p.m. and ended at 9 p.m., Historical Server calculates data item values for the hours between 3 p.m. and 6 p.m. It prorates cumulative (session) counts and uses weighted averages for cumulative percentages and rates if the start and end times specified for playback do not match the start and end times of the input session(s).