Have you tried setting large_pool_size. Don't just go on increasing size of shared_pool_size.
Set PARALLEL_AUTOMATIC_TUNING to true even though you are not going to use any parallel clause. Because of this Oracle will automatically calculate value for large_pool_size.




Reply With Quote