PL/SQL - get the procedure execution time

Get the procedure execution time

Option 1
 
set timing on
DECLARE
 STATUS VARCHAR2(200);
BEGIN  VALIDATION_PKG.VALIDATE_PERSON_REQUIRED_FIELD( STATUS => STATUS);
DBMS_OUTPUT.PUT_LINE('STATUS = ' || STATUS);
end;

Option 2
 
DECLARE
   time_before BINARY_INTEGER;
   time_after binary_integer;
   STATUS VARCHAR2(200);
BEGIN
   time_before := DBMS_UTILITY.GET_TIME;
   VALIDATION_PKG.VALIDATE_PERSON_REQUIRED_FIELD(STATUS => STATUS);
time_after := DBMS_UTILITY.GET_TIME;
dbms_output.put_line (time_after - time_before);
END;

No comments:

Post a Comment