Oracle_Performance

Explain Plan (Plan_Table)


explain plan SET STATEMENT_ID='DOCS_SIMPLE_SORT_01'
  for select * from DW_PS_EMPL_HOURS_FACT order by 1;

select 'Statement_id:'||statement_id||' (Plan:'||plan_id||') @ '||to_char(timestamp,'YYYYMMDD_HHMMSS')||' Op:'||OPERATION ||' CPU:'||cpu_cost||' IO:'||io_cost dah_plan
  from plan_table where statement_id='DOCS_SIMPLE_SORT_01'
   union
   SELECT * FROM TABLE(dbms_xplan.display) where  plan_table_output

     not like '%Plan hash value%'; --from PLAN_TABLE see /rdbms/admin/utlxplan.sql

Comments

Popular Posts