set lines 1000
set pages 1000
set trimspool on
set echo off

select 'Queries that run longer than 5 seconds' from dual
/
select * from PSQRYEXECLOG
where exectime + fetchtime > 5
order by EXECTIME desc
/
select 'Most frequently run queries' from dual
/
select oprid, qryname, count(*)
from PSQRYEXECLOG
group by oprid, qryname
having count(*) > 1
order by count(*) desc
/
--Queries with the most rows returned
select * from PSQRYEXECLOG
where numrows > 100000
order by numrows desc
/