Home » SQL & PL/SQL » SQL & PL/SQL » execution time of a query
execution time of a query [message #447596] Tue, 16 March 2010 05:41 Go to next message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
HI
I want to know that is there any way to know the execution time of a sql query.



Thanks
Dhinendra
Re: execution time of a query [message #447599 is a reply to message #447596] Tue, 16 March 2010 05:45 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This?
SQL> set timing on
SQL> select count(*) from dictionary;

  COUNT(*)
----------
       676

Elapsed: 00:00:00.25
SQL>
Previous Topic: Adding Partition fails
Next Topic: DETECT AND MOVE DUPLICATE VALUES (2 threads merged by bb)
Goto Forum:
  


Current Time: Sun Feb 16 00:39:18 CST 2025