ORACLE-10g measures CPU Time Elapsed Code:
SQL> SET SERVEROUTPUT ON;
SQL> DECLARE
2 vInteger INTEGER;
3 vResultInt INTEGER;
4 BEGIN
5 vInteger := DBMS_UTILITY.GET_TIME();
6 FOR I IN 1 .. 50000000 LOOP
7 NULL;
8 END LOOP;
9 vResultInt := DBMS_UTILITY.GET_TIME() - vInteger;
10 DBMS_OUTPUT.PUT_LINE( 'ELAPSED TIME := ' || vInteger || ' HSECS' );
11 DBMS_OUTPUT.PUT_LINE( 'ELAPSED CPU TIME := ' ||vResultInt || ' HSECS' );
12 END;
13 /
ELAPSED TIME := -1456785280 HSECS
ELAPSED CPU TIME := 220 HSECS
PL/SQL procedure successfully completed.