check optimizer mode?

[omegamark]

select substr(name,1,40),substr(value,1,40) from v$parameter where name='optimizer_mode';