Abstract
The Active Workload Repository (AWR) and SQL trace files both capture performance-relevant data on SQL and PL/SQL execution. It is undocumented that both data sources may be linked to answer questions that frequently arise during investigations of performance problems. By integrating SQL trace data with AWR, it is possible to find out whether different execution plans were used for a particular statement and at what time. Furthermore, contrary to EXPLAIN PLAN, the AWR is a reliable source for execution plans when plans for certain statements are absent from SQL trace files.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Norbert Debes
About this chapter
Cite this chapter
Debes, N. (2009). Integrating Extended SQL Trace and AWR. In: Secrets of the Oracle Database. Apress. https://doi.org/10.1007/978-1-4302-1953-8_26
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1953-8_26
Publisher Name: Apress
Print ISBN: 978-1-4302-1952-1
Online ISBN: 978-1-4302-1953-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books