oracle dbms_xplan.display_cursor查看执行计划
select sql_text,
sql_fulltext,
sql_id,
child_number,
last_load_time,
s.executions,
s.cpu_time,
s.elapsed_time,
s.plsql_exec_time,
s.users_executing,
s.px_servers_executions,
s.*
from gv$sql s
where s.sql_fulltext like '%hx_zgxt.sb_zlbsmxqd%'
order by s.last_load_time desc;
select *
from table(dbms_xplan.display_cursor('28rzb164xuctv',
0,
'ADVANCED +PEEKED_BINDS'));
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26613085/viewspace-1125668/ ，如需转载，请注明出处，否则将追究法律责任。
