Library Cache

How to Resolve ORA-13780: SQL statement does not exist

by Ed Chen
February 7, 2023February 8, 2023

ORA-13780 Tried to create a SQL tuning task for specific SQL ID, but it failed with ORA-13780. SQL> select DBMS_SQLTUNE.CREATE_TUNING_TASK ( sql_id => '21zq47mj49f7w', scope… Read More »

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

by Ed Chen
September 3, 2014July 11, 2023
2 Comments

Causes 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 »

JavaScript is not enabled. Please enable it and reload the page.