数据库修改sga

32位操作系统

alter system set sga_max_size=1600m scope=spfile;

alter system set sga_target=1600m scope=spfile;

alter system set shared_pool_size=284M scope=spfile;

--alter system set db_block_buffer=1136M scope=spfile;

alter system set log_buffer = 768000 scope=spfile;

alter system set large_pool_size=42M scope=spfile;

alter system set java_pool_size =28 M scope=spfile;

alter system set sort_area_size =768000 scope=spfile;

alter system set sort_area_retained_size =768000  scope=spfile;

 

alter system set workarea_size_policy=auto scope=both;

alter system set pga_aggregate_target=512m scope=both;

SELECT * FROM V$PGASTAT;

NAME                                                                  VALUE UNIT
---------------------------------------------------------------- ---------- ------------
aggregate PGA target parameter                                    536870912 bytes    --当前PGA_AGGREGATE_TARGET的值
aggregate PGA auto target                                         477379584 bytes    --当前可用于自动分配了的PGA大小，不应该比PGA_AGGREGATE_TARGET 小
global memory bound                                                26843136 bytes    --自动模式下工作区域的最大大小，Oracle根据工作负载自动调整。
total PGA inuse                                                     6448128 bytes
total PGA allocated                                                11598848 bytes    --PGA的最大分配
maximum PGA allocated                                             166175744 bytes
total freeable PGA memory                                            393216 bytes    --PGA的最大空闲大小
PGA memory freed back to OS                                        69074944 bytes
total PGA used for auto workareas                                         0 bytes    --PGA分配给auto workareas的大小
maximum PGA used for auto workareas                                 1049600 bytes
total PGA used for manual workareas                                       0 bytes
maximum PGA used for manual workareas                                530432 bytes
over allocation count                                                  1118    --实例启动后，发生的分配次数，如果这个值大于0，就要考虑增加pga的值
bytes processed                                                   114895872 bytes
extra bytes read/written                                            4608000 bytes
cache hit percentage                                                  96.14 percent    --命中率

 

恢复初始化状态

C:\Documents and Settings\Administrator>sqlplus/nolog

SQL> conn sys/12345678 as sysdba
已连接到空闲例程。

SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。

SQL> startup pfile=D:\oracle\product\10.2.0\admin\JC\pfile\init.ora.10620081554
ORACLE 例程已经启动。
Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             167775108 bytes
Database Buffers          436207616 bytes
Redo Buffers                7135232 bytes
数据库装载完毕。
数据库已经打开。

SQL> create spfile from pfile='E:\oracle\product\10.2.0\admin\JC\pfile\init.ora.819200817327';
文件已创建。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13636837/viewspace-604517/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13636837/viewspace-604517/