Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>