parameter « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. parameter
1.--Query v$parameter table for 'optimizer_mode'
2.determine if flashback query is enabled on your system
3.Obtain retention parm
4.show parameters block
5.show parameter type and value from v$parameter