exec dbms_lock.sleep(75);
select philosopher_id,max(wait_time) as max_wait,avg(wait_time) as avg_wait
,sum(wait_time) as total_wait,(sum(wait_time)/60)*100 as pct_wait,stddev(wait_time) as stdddev_wait
from (
select to_number(replace(event,'last ate:','')) as wait_time,philosopher_id
from log where event like 'last ate%'
)
group by philosopher_id;
pause
exit