04031

===

Shared Memory가 부족함

1. 재기동

   shutdown abort
   startup
   

2. DBMS_SHARED_POOL 패키지로 인한 SHARED POOL 이 부족한 경우

   --SHARED_POOL_RESERVED_SIZE, SHARED_POOL_SIZE 조정
   --확인
   SHOW PARAMETER shared_pool
   /*
   NAME                                 TYPE        VALUE
   ------------------------------------ ----------- ------------------------------
   shared_pool_reserved_size            big integer 644245094
   shared_pool_size                     big integer 12G
   */
   
   --설정 (size : 1024MB, 4G...)
   ALTER SYSTEM SET shared_pool_size=size SCOPE=BOTH;
   ALTER SYSTEM SET shared_pool_reserved_size=size SCOPE=BOTH;
   

   >https://docs.oracle.com/cd/E16338_01/server.112/b56311/initparams239.htm

3. Oracle Streams, XStream process에서 문제가 발생한 경우

   --STREAMS_POOL_SIZE, SGA_MAX_SIZE 조정
   --확인
   SHOW PARAMETER streams_pool_size
   SHOW PARAMETER sga_max_size
   
   --설정 (size : 1024MB, 4G...)
   ALTER SYSTEM SET streams_pool_size=size SCOPE=BOTH;
   ALTER SYSTEM SET sga_max_size=size SCOPE=BOTH;
   

4. LARGE_POOL_SIZE 가 부족한 경우

   --LARGE_POOL_SIZE 조정
   SHOW PARAMETER large_pool_size
   
   --설정 (size : 1024MB, 4G...)
   ALTER SYSTEM SET large_pool_size=size SCOPE=BOTH;