select sql_text,executions
from (
select
sql_text,executions, rank() over (order by executions desc) exec_rank
from v$sql)
where exec_rank <=5;
select sql_text,executions
from (
select
sql_text,executions, rank() over (order by executions desc) exec_rank
from v$sql)
where exec_rank <=5;