DBMS_UTILITY.GET_TIME常用于计算某段代码间的时间消耗，DBMS_UTILITY.GET_TIME返回值本身并不是指当前的时间，而是一个the number of 100ths of seconds that have elapsed from an arbitrary time.

Usage Notes

You should not use GET_TIME to establish the current time, but only to calculate the elapsed time between two events. Without GET_TIME, Oracle functions can only record and provide elapsed time in second intervals, which is a very coarse granularity in today\'s world of computing. With GET_TIME, you can get a much finer understanding of the processing times of lines in your program.

Example

DECLARE
 L_START NUMBER;
 L_END NUMBER;
 L_DIFF NUMBER;
BEGIN
 L_START := DBMS_UTILITY.GET_TIME ;
 DBMS_LOCK.SLEEP(10);
 L_END := DBMS_UTILITY.GET_TIME ;
 L_DIFF := (L_END-L_START)/100;
 DBMS_OUTPUT.PUT_LINE(\'Start: \'||to_char(L_START));
 DBMS_OUTPUT.PUT_LINE(\'End:   \'||to_char(L_END));
DBMS_OUTPUT.PUT_LINE(\'Elapsed Time: \'|| l_diff ||\' seconds...\');
END;
                                 
PL/SQL block, executed in 10.51 sec.
Start: 1719251553                   
End:   1719252554                   
Elapsed Time: 10.01 seconds...      
Total execution time 12.09 sec.

ITPub博客

使用DBMS_UTILITY.GET_TIME来捕获某段代码的执行时间

最新文章