CHAPTER 14
Running a Health Check
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.
Get Oracle SQL Tuning with Oracle SQLTXPLAIN now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
