Ödev(12.07.2017)

gistfile1.txt

DECLARE
i NUMBER;
Time_second NUMBER;
timeStart  TIMESTAMP;
timeStop  TIMESTAMP;
timeCommit  TIMESTAMP;
timeRollback  TIMESTAMP;
BEGIN
timeStart  := SYSTIMESTAMP; -- Başlangınç Zamanını atadık
FOR i in 1 .. 2000000 loop 
INSERT INTO Customers (customer_id, customer_name,city )
VALUES (1 , 'Arıkan' , 'Malatya');
END LOOP;
DBMS_OUTPUT.PUT_LINE(timeStop);
timeStop := SYSTIMESTAMP;
DBMS_OUTPUT.PUT_LINE(timeStop);
DBMS_OUTPUT.PUT_LINE('----------------------------');
DBMS_OUTPUT.PUT_LINE('Diziye insert Süresi');
DBMS_OUTPUT.PUT_LINE(SUBSTR(timeStop,15,2)-SUBSTR(timeStart,15,2)||'  Dakika');

İF SUBSTR(timeStop,18,2)<=SUBSTR(timeStart,18,2) then
DBMS_OUTPUT.PUT_LINE(SUBSTR(timeStop,18,2)-SUBSTR(timeStart,18,2)||'  Saniye');
else
DBMS_OUTPUT.PUT_LINE(SUBSTR(timeStop,18,2)-SUBSTR(timeStart,18,2)||'  Saniye');
END IF;
DBMS_OUTPUT.PUT_LINE('----------------------------');
COMMIT;
timeCommit := SYSTIMESTAMP;
DBMS_OUTPUT.PUT_LINE('Commit süresi');
DBMS_OUTPUT.PUT_LINE('----------------------------');
DBMS_OUTPUT.PUT_LINE(SUBSTR(timeCommit,21,6)-SUBSTR(timeStop,21,6)||'  Salise');
DBMS_OUTPUT.PUT_LINE('----------------------------');


ROLLBACK;
timeRollback := SYSTIMESTAMP;
DBMS_OUTPUT.PUT_LINE('Rollback süresi');
DBMS_OUTPUT.PUT_LINE('----------------------------');
DBMS_OUTPUT.PUT_LINE(SUBSTR(timeRollback,21,6)-SUBSTR(timeStop,21,6)||'  Salise');



END;

/