如何查看Oracle Parameters

如何查看数据库的parameter
方法1-show parameter
[sql] view plaincopy
<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] view plaincopy
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] view plaincopy
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
[sql] view plaincopy
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.