ora-4031 and "obj stat memory" component in Shared Pool

My customer has an application which using a lots of "temporary" table. They create so many tables but only operate once.And they are using automatic SGA management,all this cause large memory usage in shared pool, especially the "obj stat memo".

Recently they encountered

本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1277099