Time statistics

From: Omar Malik <obNOSPAMmar_at_hotmail.com>
Date: Mon, 13 Aug 2001 09:48:34 -0400
Message-ID: <9l94d011bkl_at_enews2.newsguy.com>

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? Received on Mon Aug 13 2001 - 15:48:34 CEST

This message: [ Message body ]
Next message: Heiner: "ORA-01000 exceeded max. number of open cursors"
Previous message: padderz: "Re: Q: How to obtain SID for my session?"
Next in thread: catherine_devlin_at_purpleturtle.com: "Re: Time statistics"
Reply: catherine_devlin_at_purpleturtle.com: "Re: Time statistics"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message