ORA-04031: unable to allocate bytes of shared memory

What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area in the SGA known as the shared pool. This sharable area of memory is managed as a sophisticated cache and heap manager rolled into one. It has 3 fundamental problems to overcome: The unit of … Read more