Oracle 内存分配小记

Oracle 内存分配小记

启动Oracle数据库的内存分配
Total System Global Area  389189632 bytes
Fixed Size                1345156 bytes
Variable Size            243272060 bytes  4194304+4194304+159383552+75497472=243269632 java_pool large_pool pga_aggregate_target shared_pool_size 

                                    还差 243272060 -243269632 =  2428
Database Buffers          138412032 bytes  orcl.__db_cache_size=138412032
Redo Buffers              6160384 bytes
                         
以下是spfile参数：
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__pga_aggregate_target=159383552
orcl.__sga_target=230686720
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=75497472
orcl.__streams_pool_size=0