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博客 ” ,链接:http://blog.itpub.net/26613085/viewspace-1125668/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26613085/viewspace-1125668/