Wednesday, January 7, 2009

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.

No comments:

All Rights Reserved