1、查看执行计划
set lines 222
select *from table(dbms_xplan.display_cursor(sql_id));
2、手动固化SQL执行计划
select sql_id,plan_hash_value,excutions from v$sql where sql_id='';
declare
u int ;
begin
u:=dbms_spm.load_plans_from_cursor_cache(sql_id=>'',plan_hash_value=>'',fixed=>'YES');
dbms_output.put_line('');
end;
/