Linux下oracle内存修正

1）项目在执行过程中，总是报OutOfMemory错误，调查后发现是pga设置过小。

SQL>show parameter sga

NAME                                TYPE        VALUE

----------------------------------------------- ------------------------------

lock_sga                            boolean     FALSE

pre_page_sga                        boolean     FALSE

sga_max_size                        big integer 20G

sga_target                          biginteger 20G

SQL>show parameter pga

NAME                                TYPE        VALUE

----------------------------------------------- ------------------------------

pga_aggregate_target                big integer 15G

2）修改Oracle内存大小。需要修改以下参数：

sga_max_size 

sga_target                          

pga_aggregate_target                

memory_target

memory_max_target

以上几个参数的值，存在以下关系，一定要正确设置，否则会报ORA-00823错误。

pga_aggregate_target  < sga_target  show parameter pga

NAME                                TYPE        VALUE

----------------------------------------------- ------------------------------

pga_aggregate_target                big integer 25G

SQL>show parameter memory

NAME                                TYPE        VALUE

----------------------------------------------- ------------------------------

hi_shared_memory_address            integer     0

memory_max_target                   big integer 60G

memory_target                       big integer 60G

shared_memory_address               integer     0