I need to get the execution time for each query I run. I did set the "SET TIMING ON" option. However that is giving me wierd results. Also when I do it I get the time dispay as real: 929. Is this time of query execution in milli secs?? Also where do I get the parsing and execution time separately??
If I try to run a query
select * from s_emp; with 10000 rows,
this query gives me 'Real:@90000' time if I do not minimize SQL plus. However if I minimize SQL plus, the same query is executed in 'real:@14000' time. This is puzzling. I tried the same thing on 2 diff machines. Same result.
