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:1 person found this helpful
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:
thanks a lot for the answers