Explain Plan

[Monique]

Environment Information:
* version of Oracle: 10.2.0
* Operating system: Linux


was seeing one of Oracle's Explain Plan, but I have some problems in my plan_table table that was created from the UTLXPLAN script. When a plan is performed explain plan for select count(1) from artigo4; and then the query to view the plan select * from table(dbms_xplan.display); is displayed only the ID, Operation and Name fields does not show the rows, cost, bytes, etc. and in the Plan_Table table was filled with null.

Does anyone know what's going on? How do I present this information?

Thanks ....

[victorhugomuniz]

Would not you have to give an autotrace on ???

I removed an article from the site ..

Select all

 
SET AUTOTRACE ON 
SELECT bla bla bla... 
 
Execution Plan 
---------------------------------------------------------- 
 
-------------------------------------------------------------- 
| Id  | Operation          | Name       | Rows  | Cost (%CPU)| 
-------------------------------------------------------------- 
|   0 | SELECT STATEMENT   |            |     1 |   102   (0)| 
|   1 |  SORT AGGREGATE    |            |     1 |            | 
|   2 |   TABLE ACCESS FULL| TABELA     |  4322 |   102   (0)| 
-------------------------------------------------------------- 
 
Note 
----- 
   - 'PLAN_TABLE' is old version 

[diegolenhardt]

I always used this functionality through plsql developer, f5,


does a test with him to know if it is something that is missing before, if he shows then you are doing something wrong,

I find it much simpler, squeeze f5 in the query that typing a few commands to see the same thing;)

[Monique]

Hello boys, thank you for answering, I ended up discovering what was happening was a parameter called Optimizer_Mode he was set with Rule and for that reason he was not showing up. It works with any parameter that is different from Rule

[m04m]

Hello,

If you have access to Metalink can take a look at this feature, a "Explain Plan Extended" ..
SQLT (SQLTXPLAIN) - Tool that Helps to Diagnosis SQL Performing POORly Statements [ID 215187.1]
Supported versions:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.1


SQLT (SQLTXLAIN) IS A TOOL THAT INPUTS ONE SQL STATEMENT AND OUTPUTS The set of Comprehensive Diagnostic Files for SQL Performance Analysis and Tuning.

M04m.