Listing 1: mod versus no_mod profiler report
Lines taking more than 1 percent of the total time, each run separately.
RUNID HSECS PCT OWNER UNIT_NAME LINE# TEXT
----- ----- --- ----- --------- ----------
1 550.06 48.2 OPS$TKYTE DO_MOD 9 if ( mod(cnt,1000) = 0 )
1 135.22 11.9 OPS$TKYTE DO_MOD 8 cnt := cnt + 1;
2 107.71 9.4 OPS$TKYTE NO_MOD 8 cnt := cnt + 1;
2 104.34 9.1 OPS$TKYTE NO_MOD 9 if ( cnt = 1000 )
1 67.95 6.0 OPS$TKYTE DO_MOD 6 for i in 1 .. 500000
2 64.66 5.7 OPS$TKYTE NO_MD 12 cnt := 0;
1 64.64 5.7 OPS$TKYTE DO_MOD 11 commit;
2 44.99 3.9 OPS$TKYTE NO_MOD 6 for i in 1 .. 500000
8 rows selected.
|
