Skip to content
January 20, 2011 / doganay

TIME MEASUREMENT IN SP

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Hi,
You may want to measure how much time your sp spend:

create or replace procedure measure1 as
start_time number;
end_time number;
begin

start_time := dbms_utility.get_time;

-- Your actual code here

end_time := dbms_utility.get_time;

dbms_output.new_line;
dbms_output.put_line('time: ' || (end_time - start_time) / 100 || ' seconds');

end;
/

try and pray 🙂

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

%d bloggers like this: