星期二, 8月 20, 2013

Check if Oracle parameter is dynamic/can be changed online

SQL>
select name, ISSYS_MODIFIABLE from v$parameter where name='shared_pool_size';

--Find all dynamic parameter
select name, ISSYS_MODIFIABLE from v$parameter;

other parameter:
open_cursor,
sga_target,

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...