PL/SQL

How to Use Bind Variable in Oracle

Posted on
Shareable Cursor Using bind variables can make statements with minor differences become literally the same so as to share the same cursor when executions. That means, SQL engine doesn’t have to parse those similar statements every time they are executed, it reuses the shared cursor to service millions of executions. Unshareable Cursors In contrast, dynamic […]
Performance

How to Resolve ORA-04031: unable to allocate 4216 bytes of shared memory

Posted on
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”) Causes Several kinds of memory problem can result in ORA-04031. As you can see, the above error complained specifically about the shared pool. Therefore, your database could be in one of the following situations: […]