oracle效率测试

2019独角兽企业重金招聘Python工程师标准>>>

--测试时间到毫秒
declare
    start_time   number;
    finish_time  number;
    elapsed_time number(5);
begin
    select dbms_utility.get_time into start_time from dual;

    dbms_lock.sleep(5);
    -- do something
    select dbms_utility.get_time into finish_time from sys.dual;

    elapsed_time := finish_time - start_time;

    dbms_output.put_line(elapsed_time);
end;

--测试时间到秒
declare
    start_time   char(5);
    finish_time  char(5);
    elapsed_time number(5);
begin
    select to_char(sysdate, 'SSSSS') into start_time from dual;

    dbms_lock.sleep(5);
    -- do something
    select to_char(sysdate, 'SSSSS') into finish_time from sys.dual;

    elapsed_time := finish_time - start_time;

    dbms_output.put_line(elapsed_time);
end;

转载于:https://my.oschina.net/kanlianhui/blog/172751