RAC 下看其他节点的执行计划 非共享SQL

select ORIGINATING_TIMESTAMP, MESSAGE_TEXT from table(gv$(cursor(select * from v$diag_alert_ext))) where ORIGINATING_TIMESTAMP >sysdate-0.1 and MESSAGE_TEXT like '%service%';

select * from table(gv$(cursor(select * from table(dbms_xplan.display_cursor('  ',null)))))  

select * from table(dbms_xplan.display_cursor(' ', null, 'ALLSTATS LAST +PEEKED_BINDS +PROJECTION +ALIAS +COST +BYTES +PARALLEL +PARTITION +REMOTE +OUTLINE +HINT_REPORT +NOTE'));

 select * from table(dbms_xplan.display_cursor(' ', null))
 
  select * from table(dbms_xplan.display_cursor(' ' ))