Hi List,
I am really confused by the results from the DBMS_UTILITY.get_time() and set timing on in the SQL PLUS.
Can anybody please explain this with an example.
I gave the following in the SQL PLUS
SQL > Set timing on
SQL > Select * from emp;
Elapsed: 00:00:00.08
Does this mean the command took 80 milli second or it took 800 millisecond to execute.
Now I put the same select statement in a procedure and used the DBMS_utility.get_time() before executing and after executing the statement, the values I got were different. Could somebody explain this. Does these two show the result in milli second.
Prem
