Return
-
Title
Explain plan details, CPU Cost are shown in one database but not other. -
Description
User is able to view the explain plan details but it does not show the values for CPU Cost. It does it some databases and not in other databases.
-
Cause
CPU Costing need to be turned on by the DBA. This is an Oracle feature. It is only reported by Toad if it is available. It is defaulted to off in 9.2 databases and default on in 10g databases.
-
Resolution
TEST:
Run the following in SQL Plus or command line.
1. EXPLAIN PLAN FOR SELECT * FROM yourtable;
2. SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY)
View the contents of the output. Note if it says "CPU Costing is off."
The explain plan will not display CPU Cost if CPU Costing is off. Contact your DBA to turn it on.