---查看哪些参数的名称及值,是否可以会话更改,是否可以系统更改，是否可以实例级调整,如为true则可以在对应级别上调整，否则false则要重启库方生效,比如:log_buffer
SQL> select name,value,isdefault,ISSES_MODIFIABLE,ISSYS_MODIFIABLE,ISINSTANCE_MODIFIABLE from v$parameter where name  like '%pool%';

 
NAME                           VALUE       ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISINSTANCE_MODIFIABLE
------------------------------ ----------- --------- ---------------- ---------------- ---------------------
shared_pool_size               0           TRUE      FALSE            IMMEDIATE        TRUE
large_pool_size                0           TRUE      FALSE            IMMEDIATE        TRUE
java_pool_size                 0           TRUE      FALSE            IMMEDIATE        TRUE
streams_pool_size              0           TRUE      FALSE            IMMEDIATE        TRUE
shared_pool_reserved_size      13421772    TRUE      FALSE            FALSE            FALSE
buffer_pool_keep                           TRUE      FALSE            FALSE            FALSE
buffer_pool_recycle                        TRUE      FALSE            FALSE            FALSE
global_context_pool_size                   TRUE      FALSE            FALSE            FALSE
olap_page_pool_size            0           TRUE      TRUE             DEFERRED         TRUE
 
9 rows selected

 
NAME                           VALUE       ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISINSTANCE_MODIFIABLE
------------------------------ ----------- --------- ---------------- ---------------- ---------------------
use_indirect_data_buffers      FALSE       TRUE      FALSE            FALSE            FALSE
db_block_buffers               0           TRUE      FALSE            FALSE            FALSE
buffer_pool_keep                           TRUE      FALSE            FALSE            FALSE
buffer_pool_recycle                        TRUE      FALSE            FALSE            FALSE
log_buffer                     7000064     FALSE     FALSE            FALSE            FALSE