SQL> create or replace
  2  procedure slow_proc is
  3    x int;
  4    s timestamp := systimestamp;
  5  begin
  6    select 1 into x from dual;
  7    dbms_output.put_line('This SQL took '||(systimestamp-s));
  8    s := systimestamp;
  9
 10    select count(*)  into x from dba_objects;
 11    dbms_output.put_line('This SQL took '||(systimestamp-s));
 12    s := systimestamp;
 13
 14    select count(*)  into x from dba_objects, scott.emp;
 15    dbms_output.put_line('This SQL took '||(systimestamp-s));
 16    s := systimestamp;
 17  end;
 18  /

Procedure created.

SQL> sho err
No errors.
SQL>
SQL> set serverout on
SQL> exec slow_proc
This SQL took +000000000 00:00:00.000000000
This SQL took +000000000 00:00:00.076000000
This SQL took +000000000 00:00:00.151000000

PL/SQL procedure successfully completed.