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'));