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
相关文章
[20171107]dbms_shared_pool.pin.txt
[20171107]dbms_shared_pool.pin.txt --//昨天与别人聊天提到,如果dbms_shared_pool.pin对象,可以改变对应的chunk的类型.
810 0