Explain plan window not showing cost

[rjacoby]

Hi all,

I've tried with both per-user PLAN_TABLE and a SYS synonym, to no luck.

I can run the explain plan window, and get the plan, but the "COST", "CARDINALITY" and "BYTES" columns are empty.

The user has privileges on the PLAN_TABLE and is granted the PLUSTRACE role.

What's missing?

 

[rjacoby]

Oh yeah, it's against Oracle 9.0.2.

 

[Marco Kalter]

The tables and/or indexes are probably not analyzed. Execute this for the table(s) in your query:

analyze table compute statistics

Now try the explain plan again.

------------------
Marco Kalter
Allround Automations

 

[TenGor]

Hy,

is there anywhere an overview f.e. in the online-help for the viewable columns in the explain plan?

Is there a easy way to analyze all the tables or do this within the create-statement?

------------------
Thanks for helping & looking
TenGor

 

[Marco Kalter]

The "Oracle Database Performance Tuning Guide and Reference" manual describes all plan_table columns in detail.

To gather statistics for all objects in a specific schema, you can use the dbms_stats.gather_schema_stats procedure.

------------------
Marco Kalter
Allround Automations

 

[aotte]

Any chance of getting the *_PREDICATES columns added to the list?

------------------
Hakuna Matata,

Arnoud.

 

[Marco Kalter]

Sure. I have added this to the list of enhancement requests.

------------------
Marco Kalter
Allround Automations