OraFAQ Forum: SQL & PL/SQL » time taken in executing a query.

Home » SQL & PL/SQL » SQL & PL/SQL » time taken in executing a query.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

time taken in executing a query. [message #21555]

Tue, 13 August 2002 04:57

manoj tomar
Messages: 1
Registered: August 2002

Junior Member

dear sir/madam
my question is , how can we know the time taken by a query in showing a result to us?
regards
manoj

Report message to a moderator

Re: time taken in executing a query. [message #21560 is a reply to message #21555]

Tue, 13 August 2002 08:33

Keith
Messages: 88
Registered: March 2000

Member

Depends on where you want to use it. Simplest method is thru SQL*Plus 'set timing on':

apps@8i> set timing on
apps@8i>
apps@8i>
apps@8i>
apps@8i> select 1 from dual;

1
----------
1

Elapsed: 00:00:00.78
apps@8i>

Report message to a moderator

Previous Topic:	RE: extent check
Next Topic:	A timmed trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 12:38:26 CDT 2024