Oracle 查询单挑语句运行时间

pl/sql

不考虑网络IO等影响

1 declare 
2 guidname varchar2(40):='255fc3db-815a-46c1-9187-ec0256305335';
3 timespa timestamp:=CURRENT_TIMESTAMP;
4 begin
5 EXECUTE IMMEDIATE 'select * from Bex_Img_Info where guid=:a' using in guidname;
6 DBMS_OUTPUT.put_line(CURRENT_TIMESTAMP - timespa);
7 end;
原文地址:https://www.cnblogs.com/sylvialucy/p/8484288.html