Explain Plan - Cost is null

[diamondracer]

For some reason when I run an explain plan on any query, the cost, cardinality, and bytes columns are NULL. Any idea how to get this to work? I'm connecting to DB version 11.1.0.7.0

I'm using PL/SQL Developer Version 9.0.6.1665
Thanks
Mike

 

[Marco Kalter]

Perhaps you need to analyze the table(s) to obtain statistics?

analyze table compute statistics

 

[diamondracer]

Hm, yeah I ran stats on the entire database to no avail. Cost information is available when using Oracle sql developer & toad ... strange.

 

[Marco Kalter]

Are they using the same plan table and optimizer mode?