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.
[@?/rdbms/admin/utlxpls.sql]
- optimizer_features_enable is still 9i.
[Bump up the parameter to DB version]
- System stats does not exist.
[Gather system stats]
TIP 89# : CPU cost is not shown in the execution plan
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment