View Single Post
  #14 (permalink)  
Old 08-25-2007, 12:24 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: Difference between Oracle 9i and 10g

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.
__________________
-Murali..
Reply With Quote