Method R Discussion GroupMethod R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle. |
||
|
Discuss Method R products, techniques, and events. Ask new questions or post your own responses. |
If it is for more than one SQL in a test scenario how this test will work out?
The test harness performs two kinds of tests: 1) it will test a single, poorly performing SQL statement or 2) it will test a PL/SQL code block (e.g. a procedure). If you have a procedure that has multiple SQL statements in it, the PL/SQL test option of the harness will give you an overall view of the whole procedure BUT it will not pull out the one single statement that is "bad" out of that whole code block. The trace file generated by the test execution could be profiled (using our Hotsos Profiler for example) to show you the SQL statement(s) that are the poorest performers. Then, once you have the bad query, you'd test that individually in the harness as compared to other ways of writing it.
You can execute as many tests as you wish - giving them each a different scenario name - and then compare all the alternatives to determine the best performing option. |
|
Other recent topics
Powered by FogBugz