Execution Plan

[Adelson Smania]

Hi!

I'm having a strange behaviour in my application: if I execute a query in it, the execution plan used by Oracle is different than the one used with the same SQL in PL/SQL Developer.

I've checked the OptimizerGoal parameter in TOracleSession, and is ogUnchanged.

Any tips?

 

[Marco Kalter]

Do both applications run on the same PC and from the same Oracle Home?

 

[Adelson Smania]

Hi, Marco.

Yes, both are using the same Oracle Home (in case, 10.2.0.3).

We've noticed that strange behaviour by monitoring the SQL instructions sent by our application, and executing them in PL/SQL Developer.

 

[Marco Kalter]

In that case I can only assume that either the SQL is different, or one of the applications has changed the optimizer mode.

 

[Adelson Smania]

Thanks, Marco.

The SQLs are the same. I'll verify other possibilities.