Question

我知道对单位测试的ut子,我是否在装饰测试我的储存程序时可以使用这种方法?

我不想使用JMeter或穿过任何JDBC的司机——只是试图分析所储存的面包车的业绩。

Answer 1

I don t think a unit test tool is the right approach, because you re not really making assertions about functionality. With a load test you want to know how a procedure runs with a large volume of data, of if it s called lots of times.

So you might want to run it in a loop or against a big table and use a profiler to find bootlenecks. If you re on 11g you should check out the built-in hierarchical profiler.

与此类似:

begin
    DBMS_HPROF.START_PROFILING (
       location    =>  PROF_DATA_FILE_DIR 
       , filename    =>  HPROF_RUN1_20111109 
       );

    some_pkg.generate_lots_of_work(p_id => 1234);

    DBMS_HPROF.STOP_PROFILING;

end;
/

或者在 lo中:

begin
    DBMS_HPROF.START_PROFILING (
       location    =>  PROF_DATA_FILE_DIR 
       , filename    =>  HPROF_RUN2_20111109 
       );

    for i in 1..1000
    loop
        some_pkg.do_this(p_num => i);
    end loop;

    DBMS_HPROF.STOP_PROFILING;

end;
/

显然,这 won有助于你为负荷测试生成数据。这始终是最困难的部分:

Answer 2

All of the classical vendor performance test tools, LoadRunner, Silk Performer, QALoad and Rational Performance Tester have direct to Database capability for executing performance tests on queries directly or against stored procedures.

The reason why these tools have this capability is because they generally existed in the market for a good half a decade when the standard for client=server was a two tier database thick client architecture. Most of the stuff which has shown up in the market since 2000 is pretty much web only.

友情链接