show parameter type and value from v$parameter : parameter « System Tables Views « Oracle PL / SQL






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

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>








Related examples in the same category

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