Re: Time statistics

Probably yes, but he's inserting from a loop so I would have wrote myslef a procedure
that writes to a file on the server before and after each insert.

/ Robert

<catherine_devlin_at_purpleturtle.com> wrote in message news: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
 eb -----
> 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 Received on Sat Sep 01 2001 - 14:44:47 CEST