Re: Time statistics
From: <catherine_devlin_at_purpleturtle.com>
Date: 14 Aug 2001 14:47:09 GMT
Message-ID: <9lbdld$9n$1_at_news.netmar.com>
Date: 14 Aug 2001 14:47:09 GMT
Message-ID: <9lbdld$9n$1_at_news.netmar.com>
Would this work for you?
select hsecs from v$timer;
(it's in 1/100'ths of a second)
- Catherine Devlin http://profiles.yahoo.com/arcticturtle
In article <9l94d011bkl_at_enews2.newsguy.com>, Omar Malik
<obNOSPAMmar_at_hotmail.com> writes:
>Hello
>I was wondering how to time my program in Oracle. I have an insert
>statement in a loop and I want to see how long it takes each time to execute
>the insert statement. Is there a way I can display a message box which
>shows the start time and then an end time after the insert statement, each
>iteration?
>
>
>
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net