1.总消耗时间:elapsed_time
2.cpu 占用时间: cpu_time
3.执行日期: last_active_time
4.用户等待时间:user_to wait_time
select *
from (select *
from v$sql v where v.sql_text like ' excutesqltext %' ) a
where 1=1;
1.总消耗时间:elapsed_time
2.cpu 占用时间: cpu_time
3.执行日期: last_active_time
4.用户等待时间:user_to wait_time
select *
from (select *
from v$sql v where v.sql_text like ' excutesqltext %' ) a
where 1=1;