Home » RDBMS Server » Performance Tuning » display no. of seconds elapsed
display no. of seconds elapsed [message #65421] Fri, 17 September 2004 08:21 Go to next message
Hiren
Messages: 29
Registered: September 2002
Junior Member
I would like to view no of seconds elapsed while executing the given query.

Something like this:

SQL> select * from emp;

..

..

14 records selected.

00:02:21 seconds elapsed.

Do I have to set like this: ALTER SESSION SET TIMED_STATISTICS = TRUE ?

Kindly help me.

 

 

 
Re: display no. of seconds elapsed [message #65422 is a reply to message #65421] Fri, 17 September 2004 08:34 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Type SET TIMING ON at the SQL*Plus prompt.
Previous Topic: Sql tuning, Waits
Next Topic: Performance slow due to repeated execution.
Goto Forum:
  


Current Time: Wed Feb 21 20:15:48 CST 2024