Re: Execution Times of queries

From: Chandra Pabba <chandra_pabba_at_sabre.com>
Date: Tue, 03 Aug 1999 12:43:10 -0400
Message-ID: <37A71C1D.8BF7591A@sabre.com>

Hi,

How about using SET TIME ON and SET TIMING ON in Sqlplus.

Thanks

Chandra

NetComrade wrote:

> Hi folks,
>
> I was wondering how I can measure execution times of my queries.
> I know there is some pl/sql built in function to return time, which I
> can use right before and after the query in a PL/SQL block, but is
> there are any other way besides tkprof?
>
> Thanx
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Tue Aug 03 1999 - 11:43:10 CDT