Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

Show parameters block

SQL> SQL> show parameters block 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>