You may notice that sometimes that you get the execution plan, the CPU column is not shown. Also you may get the following messge : cpu costing is off (consider enabling it)
The followings could be the main reasons :
- old plan_table.
- optimizer_features_enable is still 9i.
[Bump up the parameter to DB version]
- System stats does not exist.
[Gather system stats]