Execution Elapsed Time

1. SET TIMING ON

SQL>SET TIMING ON
SQL> select count(*) from all_objects;

  COUNT(*)
----------
      6225

Elapsed: 00:00:00.83

^ ^ ^ ^
| | | |
| | | milliseconds
| | seconds
| minutes
hours

2.SET TIME ON

SQL> SET TIME ON
13:15:29 SQL>
13:15:34 SQL>
13:15:34 SQL> select count(*) from all_objects;

  COUNT(*)
----------
      6225

13:15:36 SQL>
13:15:36 SQL>

3.DBMS_UTILITY.GET_TIME

SQL> SET SERVEROUTPUT ON
SQL> Declare
2 l_start number;
3 l_end number;
4 l_diff number;
5 ippoolid tblmippooldetail.ippoolid%type;
6 serialnumber tblmippooldetail.serialnumber%type;
7 ipaddress tblmippooldetail.ipaddress%type;
8 Begin
9 l_start := DBMS_UTILITY.GET_TIME ;
10 sp_free_aaa_ip(p_ippoolid => 1,v_serialnumber => serialnumber,v_ipaddress => ipaddress);
11 l_end := DBMS_UTILITY.GET_TIME ;
12 l_diff := (l_end-l_start)/100;
13 Dbms_output.put_line(‘Elapsed Time’|| l_diff ||’secs’);
14 END;
15 /
1 , 10 , 192.168.1.10
Elapsed Time0secs

https://community.oracle.com/thread/637096?tstart=0

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s