利用sqlprofile优化goldengate中慢的sql语句(三)
,
a.PROGRAM,
a.EVENT,
a.STATUS,
a.BLOCKING_SESSION
from gv$session a
where a.PADDR = '&addr';
select c.SQL_FULLTEXT from gv$sqlarea c where c.SQL_ID='&sql_id';
cl col
--@getplan
set feedback off
pro 'general,outline,starts'
pro
acc type prompt 'Enter value for plan type:' default 'general'
select * from table(dbms_xplan.display) where '&&type'='general';
select * from table(dbms_xplan.display(null, null,'advanced -projection')) where '&&type'='outline';
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST')) where '&&type'='starts';
set feedback on
undef type