show parameters block : parameter « System Tables Views « Oracle PL / SQL





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>

 










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 parameter type and value from v$parameter