How to calculate query response time?

[hamidious]

Ok, it might be a newbie question as it seems simple enough.

But I have an sql query and wish to know the response time for it. How can I acheive this? Is it possible to do this using sql worksheet only without a tool? I have seen some tools that I can't start like analyze and optimization manager. They seem to be able to do this but I hope I don't have to use them.

Note: I am using oracle 9i, but I doubt that changes anything.

[stecal]

There are several "times" involved, but I'm guessing you want the overall time.

SQL> set timing on
SQL> select count(line)
2 from dba_source
3 where owner in
4 ('HR','OE','PM','SH','QS_ADM','QS','QS_WS','QS_ES' ,'QS_OS','QS_CBADM','QS_CB','QS_CS');

COUNT(LINE)
-----------
646

Elapsed: 00:00:01.00

[hamidious]

That's exactly what I needed,
Thank you.