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