Abstract:
Techniques that improve manageability of systems. Techniques are provided for creating different types of baselines that are more flexible and dynamic in nature. A future-based baseline may be created defining a period of time, wherein at least a portion of the period of time is in the future. A baseline may be created that is a composite of multiple baselines. In general, baselines may be specified having one or more periods of time that are either contiguous or non-contiguous. A template for creating a set of baselines based on a set of time periods may also be created, where the template can be used to create a baseline for each of the set of time periods. A moving window baseline may be created having an associated time window that changes with passage of time, where accordingly the data associated with the baseline may also dynamically change with passage of time.
Abstract:
Aspects of the present disclosure describe systems and methods for providing active session history data to users for use in database performance analysis. In various aspects, active session history data obtained from monitoring a database and/or database system over a period of time may be segmented into multiple dimensions. The segmented data may be subsequently provide and/or displayed on one or more interfaces, such as a graphical user interface, to users. The interface may visualize the dimensional ASH data in a variety of ways, such as through icons, graphs, charts, histograms, temporal delineations, treemaps, etc.
Abstract:
Aspects of the present disclosure describe systems and methods for providing active session history data to users for use in database performance analysis. In various aspects, active session history data obtained from monitoring a database and/or database system over a period of time may be segmented into multiple dimensions. The segmented data may be subsequently provide and/or displayed on one or more interfaces, such as a graphical user interface, to users. The interface may visualize the dimensional ASH data in a variety of ways, such as through icons, graphs, charts, histograms, temporal delineations, treemaps, etc.
Abstract:
A method for determining event counts for a database system includes capturing samples for the active sessions based on a pre-defined sampling frequency and identifying events from the captured samples. The method further includes determining the wait time for each of the identified events and determining an event count for the active sessions using a harmonic mean. The harmonic mean is a summation of the maximum of either one or the ratio of the sampling frequency to the determined wait time for each of the identified events.
Abstract:
Techniques that improve manageability of systems. Techniques are provided for creating different types of baselines that are more flexible and dynamic in nature. A future-based baseline may be created defining a period of time, wherein at least a portion of the period of time is in the future. A baseline may be created that is a composite of multiple baselines. In general, baselines may be specified having one or more periods of time that are either contiguous or non-contiguous. A template for creating a set of baselines based on a set of time periods may also be created, where the template can be used to create a baseline for each of the set of time periods. A moving window baseline may be created having an associated time window that changes with passage of time, where accordingly the data associated with the baseline may also dynamically change with passage of time.
Abstract:
A method for determining event counts for a database system includes capturing samples for the active sessions based on a pre-defined sampling frequency and identifying events from the captured samples. The method further includes determining the wait time for each of the identified events and determining an event count for the active sessions using a harmonic mean. The harmonic mean is a summation of the maximum of either one or the ratio of the sampling frequency to the determined wait time for each of the identified events.