SQL Detail from v$ System Views

Execution Info from SQL Area

-- Execution Info from SQL Area
SELECT concurrency_wait_time,
executions,
ROUND(concurrency_wait_time/executions,2) as AvgWaitPerExec,
sql_text
FROM v$sqlarea
WHERE executions > 0
ORDER by 1 desc;