--Query v$parameter table for 'optimizer_mode' : parameter « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. parameter

--Query v$parameter table for 'optimizer_mode'

 

SELECT name, value
FROM   v$parameter
WHERE  name = 'optimizer_mode';


--








Related examples in the same category

1.determine if flashback query is enabled on your system
2.Obtain retention parm
3.show parameters block
4.show parameter type and value from v$parameter