OraFAQ Forum: Forms » time retrieval after execution of query

Home » Developer & Programmer » Forms » time retrieval after execution of query

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

time retrieval after execution of query [message #87635]

Mon, 24 January 2005 19:45

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 06:11:55 CDT 2024