My question is: Does OPTIMIZER_GOAL/OPTIMIZER_MODE parameter in preferences working?? Last time i was tracing sql’s from sqlnav session, i didn’t observed setting OPTIMIZER_MODE parameter. I know that in earlier version of sqlnav it was worki’n. (as OPTIMIZER_GOAL).
So i traced session, where i change optimizer_goal and default date format.
Tkprof file in attachement. In this file is part about setting date format, but any word about OPTIMIZER_MODE.
If i’m thinking incorrectly please correct my observations.
session.zip (108 KB)