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