select
sql_text,
sql_id,
First_load_time,
last_active_time,
executions
from v$sqlarea
where sql_text like'%%'
在根据sql_id获取执行计划
select * from table(dbms_xplan.display_cursor(sql_id,'0'));
select
sql_text,
sql_id,
First_load_time,
last_active_time,
executions
from v$sqlarea
where sql_text like'%%'
在根据sql_id获取执行计划
select * from table(dbms_xplan.display_cursor(sql_id,'0'));