Re: Measure querytime
From: Hassan Ayub <hassan_ayub_at_yahoo.com>
Date: 7 Jul 2002 07:53:12 -0700
Message-ID: <1df2b71.0207070653.2891bd03_at_posting.google.com>
Date: 7 Jul 2002 07:53:12 -0700
Message-ID: <1df2b71.0207070653.2891bd03_at_posting.google.com>
Hi there,
I presume you are talking abut the SQL* PLus environment. Use the timing variable and turn it on using the following command:
set timing on
after this whenever you will run your query it will give you the elapsed time for that query.
good luck!!!
Hassan Ayub Received on Sun Jul 07 2002 - 16:53:12 CEST