Is there a way to get query duration on server side ?
Oracle 11.2.0.1 :
we can get informations on querys in ASH view. so we can have elasped time of a query, but with parrallel processing, we get db time , wich is much more than real time.
For example the user report query wich takes 20 sec, (in place of 0.5 sec), but when we get information on sql_id in the ASH view, the query time is 96 seconds,
I know that it is possible to to "set timing on" in sqlplus, to get this real time in a client tools, but we would like get the real time (ex : < 20 sec) from the server side in history view, or grid reports.