Active Session History
Active Session History (ASH) is absolutely new in Oracle Database 10g. Very simply, it is both the recording and retention—short and long term—of crucial session-state information. The reasoning behind the provisioning of this very interesting data is to allow the performance analyst to perform on-the-spot analysis of a current session as well as to be able to look at the overall breakdown of session-related information in the short term.
Session-State Information
You saw an example of a session-related analysis in Chapter 10, which presented the details of current performance issue and drilled down into the details of a Top Session. This section illustrates how ASH helps collect this information. The Database Control in ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
