PL/SQL Tip #1

Query v$parameter view for BD parameters checking.
In this example I'm looking for the selected optimizer mode.

select value from v$parameter where name = 'optimizer_mode';

Enjoy.