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.

 

 

 

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Sql tuning, Waits
Next Topic: Performance slow due to repeated execution.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 17:43:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.