timing unconditional loop : Timing « SQL Plus « Oracle PL / SQL






timing unconditional loop

   
SQL>
SQL>  set timing on
SQL>
SQL>  declare
  2      l_idx         pls_integer := 0;
  3      l_some_string varchar2(255);
  4    begin
  5      loop
  6        l_idx := l_idx + 1;
  7        exit when l_idx = 100000;
  8        l_some_string := rpad('*',254,'*');
  9      end loop;
 10    end;
 11    /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.15
SQL>
SQL>  set timing off
SQL>
SQL>
SQL>

   
    
  








Related examples in the same category

1.Time command
2.Time and autotrace a big table
3.Time query for a huge table
4.time a query with where clause
5.Time lower text function
6.Loop timing
7.Statistics query Timing on index
8.Performace difference between sql and pl/sql
9.TIMING table copying
10.Timing passing table collection parameter to a procedure