This content has been marked as final. Show 3 replies
Set below at session level & get explain plan again
alter session set "_optimizer_cost_model"=cpu;
Also , TIME specified in explain plan is not the response time of the query its time calculated by optimizer based on stats available on undelying objects
I hope you are looking for below link:
Oracle included time column in version 10g.
So if you currently run 9i, and use your own SQL scripts to report execution plans (instead of using dbms_xplan.display()) you may want to add a time column to your output. The following pl/sql block is all you need to get going: