PL/SQLで時間を計測する
DECLARE StartTime NUMBER; EndTime NUMBER; ElapsedTime NUMBER; i BINARY_INTEGER; j BINARY_INTEGER; BEGIN -- 計測開始 StartTime := DBMS_UTILITY.GET_TIME; for i IN 1..1000 LOOP for j IN 1..1000 LOOP NULL; -- 何らかの処理 END LOOP; END LOOP; -- 計測終了 EndTime := DBMS_UTILITY.GET_TIME; ElapsedTime := ( EndTime - StartTime ) / 100; DBMS_OUTPUT.PUT_LINE( TO_CHAR( ElapsedTime, '9999.99' )||'秒' ); END;