SQL Bind Variables, How and Whyby Ed ChenJanuary 24, 2019April 26, 2023Bind Variables Shareable Cursor Using bind variables can make statements with minor differences become literally the same so as to share the same cursor when… Read More »SQL Bind Variables, How and Why
How to Resolve ORA-04031: unable to allocate 4216 bytes of shared memoryby Ed ChenSeptember 3, 2014July 11, 20232 CommentsCauses of ORA-04031 Found ORA-04031 in the alert log. ORA-04031: unable to allocate 4216 bytes of shared memory ("shared pool","unknown object","sga heap","library cache") Several kinds… Read More »How to Resolve ORA-04031: unable to allocate 4216 bytes of shared memory