PL/SQL timers and where things are kept...

[rigatoni]

Check out the Oracle supplied dbms_utility package's get_time procedure. It gives times in hundredths of a second.

Here's an example:

sys@AMSAA> declare
2
3 l_start number;
4 l_end number;
5 l_dummy number;
6
7 begin
8
9 l_start := dbms_utility.get_time;
10
11
12 select count(*)
13 into l_dummy
14 from user_objects;
15
16 l_end := dbms_utility.get_time;
17
18
19 dbms_output.put_line('Time to run: ' ||
to_char(l_end - l_start) );
20
21 end;
22
23 /
Time to run: 5

PL/SQL procedure successfully completed.