DBMS_UTILITY.GET_TIME常用于计算某段代码间的时间消耗，DBMS_UTILITY.GET_TIME返回值本身并不是指当前的时间，而是一个the number of100ths 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

			[sql] view plaincopy
			
 print?
		
			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.

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