Home » Developer & Programmer » Forms » time retrieval after execution of query
time retrieval after execution of query [message #87635] Mon, 24 January 2005 19:45 Go to next message
Nilesh Kunte
Messages: 30
Registered: December 2004
Location: Indore
Member
I want to see that my query has completed in a particular amount of time. Say if I query
" select * from emp;"
then how can i know that the above query has completed in say 10 milliseconds or so.

Report message to a moderator

Re: time retrieval after execution of query [message #87636 is a reply to message #87635] Mon, 24 January 2005 21:01 Go to previous message
sanjiban
Messages: 10
Registered: January 2005
Junior Member
spool ON;
SET ECHO ON;
select to_char(sysdate,'dd-mon-yyyy hh24:mi:ss') "Start Time" from dual;

select * from emp;

select to_char(sysdate,'dd-mon-yyyy hh24:mi:ss') "End Time" from dual;

spool off;

Report message to a moderator

Previous Topic: PRE-UPDATE error
Next Topic: ORA-12203:TNS:unable to connect to destination ERROR
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 08 01:18:10 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.