Skip to content

SQL scripts used for Average Active Sessions presentation at RMOUG 2007

License

Notifications You must be signed in to change notification settings

jberesni/AAS-SQL

Repository files navigation

AAS-SQL

SQL scripts used for Average Active Sessions presentation at RMOUG 2007

Title:

Average Active Sessions: the magic metric?

Abstract:

The Oracle 10g RDBMS exposes a conceptual, architectural and user-interface framework for identifying and diagnosing performance problems that uses database time as the core measure of performance impact. The wait-model performance analysis approach now in wide use by experienced DBAs has been formally embedded into Oracle 10g. One key new concept introduced is that of the time-normalized DB time, referred to formally as Average Active Sessions. This presentation will discuss the origin and meaning of Average Active Sessions and its visibility and usage in Oracle 10g, including ASH, AWR, V$ tables, sysmetrics and server alerts, and Enterprise Manager. We will focus on both theoretical and practical aspects of this important metric.

Files:

About

SQL scripts used for Average Active Sessions presentation at RMOUG 2007

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published