Re: timing estimate of queries
From: Anurag Varma <avdbi_at_hotmail.com>
Date: 25 Aug 2001 19:01:47 -0700
Message-ID: <7171ca2d.0108251801.60d74362_at_posting.google.com>
Date: 25 Aug 2001 19:01:47 -0700
Message-ID: <7171ca2d.0108251801.60d74362_at_posting.google.com>
In sqlplus:
set timing on
<--your query-->
SQL
SELECT hsecs FROM V$TIMER;
--> Gives time in 1/100secs precision
In PL/SQL
DBMS_UTILITY.GET_TIME gives time in 1/100secs precision
Anurag
arunbhat01_at_yahoo.com (Arun) wrote in message
> Is there any way i an get a timing estimate on my queries in ORacle?
> My hunch is no but if there is then please let me know.
>
> -Arun
Received on Sun Aug 26 2001 - 04:01:47 CEST