Analise de Queries.

######### Queries mais executadas:

SELECT substr(sql_text,1,40) "SQL", count(*), sum(executions) "TotExecs"
FROM v$sqlarea
WHERE executions <> 30
group by sql_text
ORDER BY 2;

######### Última querie a ser executada:
select vs.username, vs.osuser, vq.executions, vq.first_load_time FT_LOAD, vq.last_load_time LT_LOAD,vq.sql_text ---, first_load_time
from v$sql vq,V$session vs
where vq.last_load_time = (select max(last_load_time) from v$sql)
and vq.sql_id=vs.sql_id
order by 1 desc;