show parameters block : show « SQL Plus « Oracle PL / SQL






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>

 








Related examples in the same category

1.SHOW USER
2.show parameter timed_statistics