CHAPTER 11
Building Good Test Cases
Occasionally there are tuning problems where the solution is not obvious from the examination of the SQLTXTRACT or SQLTXECUTE report. All the usual suspects have been eliminated and a more thorough investigation may be required. In cases like these it is useful to build a test case to allow experimentation away from the main environment. If you are investigating a problematic SQL in a test environment, normally you would try and make the environment the same as the environment you are attempting to replicate. This is often very difficult to do because there are many factors affecting an environment that need ...
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.
