Oracle Parameters

如何查看数据库的parameter

方法1-show parameter

<pre name="code" class="sql">SQL>show parameter NAME TYPE VALUE ————————— ———– —————————— background_core_dump string partial background_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN \ORCL\BDUMP backup_tape_io_slaves boolean FALSE bitmap_merge_area_size integer 1048576 blank_trimming boolean FALSE

SQL>show parameter area NAME TYPE VALUE ————————— ———– —————————— bitmap_merge_area_size integer 1048576 create_bitmap_area_size integer 8388608 hash_area_size integer 131072 sort_area_retained_size integer 0 sort_area_size integer 65536 workarea_size_policy string AUTO

方法2-V$Parameter

SQL> SELECT name,value,isses_modifiable,issys_modifiable FROM v$parameter WHERE name like ‘%sga%’; NAME VALUE ISSES ISSYS_MOD ————— ————— —– ——— sga_max_size 612368384 FALSE FALSE pre_page_sga FALSE FALSE FALSE lock_sga FALSE FALSE FALSE sga_target 612368384 FALSE IMMEDIATE

V$Parameter和Show Parameter的区别

V$Parameter能得到更多的信息，但show parameter更简单而且它会自动完成“通配”

如何修改数据库的parameter

ALTER SYSTEM set parameter = value SCOPE = MEMORY; ALTER SYSTEM set parameter = value SCOPE = SPfile; ALTER SYSTEM set parameter = value SCOPE = BOTH;-- MEMORY - This affects the database now; but will not remain after a restart.
-- SPfile - This does not change the instance immediately, but will modify the SPfile takes effect after a restart.
-- BOTH - change both the current instance and the spfile.


转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7615345
======EOF======