plsql执行多条mysql_PLSQL批量Forall操作性能提升详解

首先创建测试表

create table test1 (c1 number , c2 number ,c3 number) ;

create table test2 (c1 number , c2 number ,c3 number) ;

开始测试

SQL> declare

2

2    l_stat_sql  varchar2(2000) := 'select value from v$mystat ms, v$statname sn where ms.STATISTIC# = sn.STATISTIC# and name = :1 ';

3    type t is table of test2%rowtype ;

4    l t := t() ;

5    l_undo_stat1 int;

6    l_undo_stat2 int;

7    l_undo_stat3 int;

8    l_redo_stat1 int;

9    l_redo_stat2 int;

10    l_redo_stat3 int;

11    l_time_stat1 int;

12    l_time_stat2 int;

13    l_time_stat3 int;

14  begin

15    l_time_stat1 := dbms_utility.get_time ;

16    execute immediate l_stat_sql  into l_redo_stat1 using 'redo size';

17    execute immediate l_stat_sql  into l_undo_stat1 using '