You are getting error – ORA-04031: unable to allocate bytes of shared memory in the Oracle database.
Solution
From the Oracle documentation,
ORA-04031: unable to allocate nn bytes of shared memory
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters “shared_pool_reserved_size” and “shared_pool_size”. If the large pool is out of memory, increase the INIT.ORA parameter “large_pool_size”.
First, you can restart the instance to reclaim the shared memory. But, if the error is still persist, increase the value of parameter shared_pool_size.
