Home » RDBMS Server » Server Administration » Re: running pl/sql script 100 times and get the time elapsed
Re: running pl/sql script 100 times and get the time elapsed [message #374923] Wed, 11 July 2001 17:17
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Try something like this...

DECLARE
t1 PLS_INTEGER;
BEGIN
t1 := DBMS_UTILITY.get_time;

-- do your stuff here...

t2 := DBMS_UTILITY.get_time;

-- DBMS_OUTPUT.put_line ('hundredths of a sec = ' || TO_CHAR (DBMS_UTILITY.get_time - t1) );
insert into MY_LOG values (DBMS_UTILITY.get_time - t1, sysdate, 'My PL/SQL script name');
END;
/

Report message to a moderator

Previous Topic: Re: Restore using an update command
Next Topic: Re: Simple Update
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 02:44:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.