Abstract
The SQL health check script is not SQLT. It is a completely separate utility downloaded from a different Metalink note and used in a different way. Why is it even mentioned in this book? SQLHC is considered a backup option when SQLT cannot be installed. This does not happen very often, but when it does it is usually because of site restrictions. There are many reasons for this:
-
Not allowed to install anything on production (security reasons).
-
Not allowed to install anything on production (fear of affecting production).
-
Installation and testing procedures take too long and you have a problem on production.
-
Don’t trust SQLT.
-
SQLT is too complicated.
-
Not enough space to install SQLT.
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). Running a Health Check. In: Oracle SQL Tuning with Oracle SQLTXPLAIN. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4810-1_14
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4810-1_14
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