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 contrary, dynamic […]
Performance

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

Posted on
Found an error in alert log.ORA-04031: unable to allocate 4216 bytes of shared memory (“shared pool”,”unknown object”,”sga heap”,”library cache”) CausesSeveral 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:Small shared pool size: If […]