Loop timing : Timing « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. Timing

Loop timing

   
SQL>
SQL>
SQL>  set timing on
SQL>
SQL>  declare
  2      some_string varchar2(255);
  3    begin
  4      for idx in 1 .. 100000 loop
  5        some_string := rpad('*',254,'*');
  6      end loop;
  7    end;
  8    /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.05
SQL>
SQL> set timing off
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.timing unconditional loop
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