Few days back, while on a visit to client place, came across ORA-04031 on an oracle 10g database. ORA-04031: "unable to allocate 4096 bytes of shared memory ("shared pool", "object_name", "alloc type(2,0)" ...)" Many good articles are available on shared pool management and ORA-04031, but i really like the two mentioned below :- 1. http://blog.tanelpoder.com/2009/06/04/ora-04031-errors-and-monitoring-shared-pool-subpool-memory-utilization-with-sgastatxsql/Continue reading ORA-04031