Abstract
Welcome to the world of fast Oracle SQL tuning with SQLTXPLAIN, or SQLT as it is typically called. Never heard of SQLT? You’re not alone. I’d never heard of it before I joined ORACLE, and I had been a DBA for more years than I care to mention. That’s why I’m writing this book. SQLT is a fantastic tool because it helps you diagnose tuning problems quickly. What do I mean by that? I mean that in half a day, maximum, you can go from a slow SQL to having an understanding of why SQL is malfunctioning, and finally, to knowing how to fix the SQL.
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
© 2013 Stelios Charalambides
About this chapter
Cite this chapter
Charalambides, S. (2013). Introduction to SQLTXPLAIN. In: Oracle SQL Tuning with Oracle SQLTXPLAIN. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4810-1_1
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4810-1_1
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4809-5
Online ISBN: 978-1-4302-4810-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books