Oracle 查找执行过的sqltext

方式一：SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(to_char('&sql_id'),NULL));

方式二：select sql_text from v$sqltext where sql_id='&sqlid' and address = (select address from v$sqltext where sql_id ='&sqlid' and piece=0 and rownum<2) order by piece;

方式三：select * from table(dbms_xplan.display_awr('&sqlid','&plan',null,'advanced'));

方式四：select * from dba_hist_sqltext where SQL_ID='&sql_id';

如果显示不全，试试

设置1：set lines 9999   

set pages 9999

设置2：set long 9999