Oracle PL/SQL block to run a query multiple times and measure time.

oracle-plsql-measure-time.sql

SET TIMING ON

DECLARE
    START_TIME PLS_INTEGER;
    COUNT_ROW NUMBER;
BEGIN
	FOR I IN 1..10 LOOP
        START_TIME := DBMS_UTILITY.GET_TIME();
		SELECT COUNT(*) INTO COUNT_ROW FROM (SELECT * FROM PERSON ORDER BY LASTNAME ASC) WHERE ROWNUM <= 50;
        DBMS_OUTPUT.PUT_LINE('Selected ' || COUNT_ROW || ' in ' || (DBMS_UTILITY.GET_TIME() - START_TIME) || '/100 seconds');
	END LOOP;
END;
/