Elapsed Time per exec (secs)
Can we get distributed value of Elapsed Time per exec(secs) of query in oracle ??
as per my understanding,
Elapsed Time per exec(secs) :- Total execution time taken by a query which includes sum total of DB Time for query + non-idle wait time.
what could be the dynamic v$ or x$ views from where i can extract distributed values ??
| Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 10,788.13 | 1 | 10,788.13 | 11.08 | 86.04 | 0.20 | 0u4n5jmu32w3a | BEGIN SYS.KUPW$WORKER.MAIN('S... | |
| 10,745.25 | 0 | 11.04 | 86.24 | 0.09 | 0kwk7211pw296 | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... | |
| 10,509.08 | 0 | 10.79 | 25.75 | 68.55 | ajnp55vta55cy |
0