Abstract
Tracing session activity is at the heart of most SQL performance tuning exercises. Oracle provides a rich set of tools to trace SQL activity. This chapter introduces the Oracle SQL trace facility and shows you how to set up SQL tracing in your environment. Oracle provides numerous “events” that help you perform various types of traces.
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
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2013 Sam R. Alapati
About this chapter
Cite this chapter
Alapati, S.R., Kuhn, D., Padfield, B. (2013). Tracing SQL Execution. In: Oracle Database 12c Performance Tuning Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6188-9_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6188-9_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6187-2
Online ISBN: 978-1-4302-6188-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books