Resolving the problem of insufficient allocation of Oracle database shared memory

problem: ORA-04031: Unable to allocate19204bytes of shared memory ("sharedPool","UnknownObject","SGA Heap (1,0)","Session param values") error Reason: The shared memory is too small, the memory allocated to the shared pool is not sufficient to satisfy the user request, or there is some fragmentation and there is no valid use of the reserved area, resulting in the inability to allocate the appropriate share. The system global Region (SGA) of an Oracle routine contains several memory regions (including buffer cache, shared pool, Java pool, large pool, and redo log buffer) SGA=db_cache+shared_pool+java_pool+Large_pool processing Method: Manually resize the SGA, and then reassign the size of the four large memory areas. The main increase is shared memory and buffered cache. SQL> Show SGA;//View the specific size information for the SGA. SQL>show parameter Sga_max_size//View the maximum SGA valueSQL> Show Parameter Shared_pool//View shared MemorySQL>show parameter Db_cache//View data CacheSQL> Alter systemSetSga_max_size = 500M scope=spfile;//Modify the SGA maximum valueSQL> Alter systemSetShared_pool_size =200m Scope=spfile;//Modify Shared MemorySql> alter systemSetDb_cache_size =250m Scope=spfile;//Modifying the data cacheSql> alter systemSetJava_pool_size =144m scope=spfile; SQL> Alter systemSetLarge_pool_size =24m scope=SPFile; System default 150 threads allocation: SGA (164M)=db_cache (24M) +shared_pool (80M) +java_pool (48M) +Large_pool (8M) The knowledge about Oracle database shared memory allocation problem is introduced here, hope this introduction can bring you some harvest! 

Resolving the problem of insufficient allocation of Oracle database shared memory