Oracle PL/SQL/System Tables Views/parameter

determine if flashback query is enabled on your system

   <source lang="sql">

SQL> SQL> select value from v$parameter where name = "undo_management"; VALUE

---

AUTO 1 row selected. SQL> SQL> --

</source>
   
  

Obtain retention parm

   <source lang="sql">

SQL> -- SQL> SQL> select value from v$parameter where name = "undo_retention"; VALUE

---

900 1 row selected. SQL> SQL> --

</source>
   
  

--Query v$parameter table for "optimizer_mode"

   <source lang="sql">

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

--

</source>
   
  

show parameters block

   <source lang="sql">

SQL> SQL> SQL> SQL> select name name_col_plus_show_param,

 2         decode(type,1,"boolean",2,"string",
 3                     3,"integer",4,"file",
 4                     6,"big integer","unknown") type,
 5         value value_col_plus_show_param
 6    from v$parameter
 7   where upper(name) like upper("%block%")
 8   order by name_col_plus_show_param,rownum
 9  /

NAME TYPE VALUE

---

----------- ------------------------------

db_block_buffers integer 0 db_block_checking string FALSE db_block_checksum string TRUE db_block_size integer 8192 db_file_multiblock_read_count integer 128 SQL> SQL>

</source>
   
  

show parameter type and value from v$parameter

   <source lang="sql">

SQL> SQL> select name name_col_plus_show_param,

 2             decode(type,1,"boolean",2,"string",
 3                         3,"integer",4,"file",
 4                         6,"big integer","unknown") type,
 5             value value_col_plus_show_param
 6  from v$parameter
 7  where upper(name) like upper("%block%")
 8  order by name_col_plus_show_param,rownum;

NAME TYPE VALUE

---

----------- ------------------------------

db_block_buffers integer 0 db_block_checking string FALSE db_block_checksum string TRUE db_block_size integer 8192 db_file_multiblock_read_count integer 128 SQL> SQL>

</source>