davey23uk, bore, pando
Thanks for your help. Yes, we plan to put in bind variables. However that will take time to correct and implement. So till then I was just trying to understand why it is happening. I am following up with oracle support too. Technically all unused part of shared pool excluding PINNNED/KEPT packages can be overwritten and allocated. So this error should not happen. I know it may not be as simple. So I want to know if memory allocated by each session as defined by session_cached_cursors is also not replaceble. Does it stay even in case of ALTER SYSTEM FLUSH SHARED_POOL. Thanks