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;