How to view a SQL execution time accurately, is not a time of PLSQL back, this time includes the time, nor up sqlplus connection set timing on time, hope that other ways to see the exact time, thank you

CodePudding user response:

Look at the real execution plan execution time is there anything you want?

CodePudding user response:

Execution plan seems to be no real time, it is expected

CodePudding user response:

The building Lord says is the execution time?

CodePudding user response:

V $SQL view

CodePudding user response:

DECLARE
STR VARCHAR2 (10000);
Va VARCHAR2 (10000);
D1 DATE;
D2 DATE;
The BEGIN
D1:=SYSDATE;
STR:='SELECT 1 FROM DUAL;
The EXECUTE IMMEDIATE STR
INTO the va;
D2:=SYSDATE;
Dbms_output. Put_line (round ((- d1, d2) * 24 * 60 * 60));
END;