Abstract
Chapter 3 focused on the plans that the CBO made. It is now time to look at how those plans work out in practice. I will explain the traditional ways of gathering and analyzing runtime data as well as a newer complementary approach called the SQL performance monitor. To fully understand SQL performance, it is very important to understand the role of workareas and the shortcuts the runtime engine uses to minimize overhead, and both of these topics are covered in this chapter.
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
© 2014 Tony Hasler
About this chapter
Cite this chapter
Hasler, T. (2014). The Runtime Engine. In: Expert Oracle SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-5978-7_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-5978-7_4
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-5977-0
Online ISBN: 978-1-4302-5978-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books