calculate total running time of a SQL statement??

Hi...

In my database, I find the "cpu time" of running a sql statment is always zero. In fact, I waits for a while to get the results.

Does the cpu time isn't include the io time?

And, how can I calculate the total excution time of a SQL command??

thanks...

Where are you getting the cpu time from?

For a small query the cpu time could be 0.00 seconds due to rounding. Usually it is physical i/o time that you wait for.

Search on "trace" and "tkprof" for more.

OOOPS! I forgot - you will need "timed_statistics=true". It can go in init.ora or be set with ALTER SESSION or ALTER SYSTEM.
(I put it in init.ora 4 years ago and haven't thought about it since!)