如何查看Oracle数据库的parameter
如何查看Oracle数据库的parameter
如何查看Oracle数据库的parameter
方法1-show parameter
- 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.
更多Oracle相关信息见Oracle 专题页面 http://www.bkjia.com/topicnews.aspx?tid=12
评论暂时关闭