Oracle PL/SQL/System Tables Views/parameter

determine if flashback query is enabled on your system

 
SQL>
SQL> select value from v$parameter where name = "undo_management";
VALUE
------------------------------------------------------------------------------------------------------------------------------------------------------
AUTO
1 row selected.
SQL>
SQL> --

Obtain retention parm

 
SQL> --
SQL>
SQL> select value from v$parameter where name = "undo_retention";
VALUE
------------------------------------------------------------------------------------------------------------------------------------------------------
900
1 row selected.
SQL>
SQL> --

--Query v$parameter table for "optimizer_mode"

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

--

show parameters block

 
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>

show parameter type and value from v$parameter

 
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>