Oracle Parameters

最新推荐文章于 2024-08-12 15:58:26 发布

iteye_4537

最新推荐文章于 2024-08-12 15:58:26 发布

阅读量322

点赞数

文章标签：数据库

如何查看数据库的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.

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