Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>