SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 11.2.0.0.0
有关内存的参数
● 自动内存管理特性
SGA与PGA根据实例的需要自动扩展和收缩,只需要设置两个与内存有关的参数memory_target和memory_max_target
默认情况:
SQL> show parameter memory_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 0
SQL> show parameter memory_max_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 0
如果需要使用自动内存管理,需要设置的参数
memory_target =350MB;
memory_max_target=500MB;
sga_target=0;
pga_aggregate_target=0;
SQL> alter system set memory_target=350M scope=spfile;
System altered.
SQL> alter system set memory_max_target=500M scope=spfile;
System altered.
SQL> alter system set sga_target=0 scope=spfile;
System altered.
SQL> alter system set pga_aggregate_target=0 scope=spfile;
System altered.
SQL> show parameter db_cache_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 0
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size 1337632 bytes
Variable Size 390072032 bytes
Database Buffers 125829120 bytes
Redo Buffers 5869568 bytes
Database mounted.
Database opened.
● diagnostic_dest自动诊断信息库位置
该参数代替以前的user_dump_dest、background_dump_dest、core_dump_dest等初始化参数
ADR主目录默认位置
/diag/rdbms//
● 与结果高速缓存有关的新参数
结果高整缓存(result cache)是在SGA中
SQL> show parameter result_cache_mode
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
result_cache_mode string MANUAL
与结果高整缓存相关的参数
result_cache_max_result integer 5
result_cache_max_size big integer 0
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
● 控制DDL锁超时的参数
SQL> show parameter ddl_lock_timeout
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
ddl_lock_timeout integer 0
阅读(1314) | 评论(0) | 转发(0) |