On Shared Pool

Invalidations – do you gather statistics, perform grants, add indexes and the like.

https://coskan.wordpress.com/2007/09/14/what-i-learned-about-shared-pool-management/

https://orainternals.wordpress.com/2009/01/15/a-stroll-through-shared-pool-heaps/#more-305

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1513005503967

https://jonathanlewis.wordpress.com/2007/01/05/bind-variables/

https://jonathanlewis.wordpress.com/2015/01/14/bind-effects/

 

http://enkitec.tv/2012/05/19/oracle-troubleshooting-ora-4031-errors-and-shared-pool-memory-troubleshooting/

http://blog.tanelpoder.com/2009/06/04/ora-04031-errors-and-monitoring-shared-pool-subpool-memory-utilization-with-sgastatxsql/

Master Note for Diagnosing ORA-4031 (Doc ID 1088239.1)

Troubleshooting and Diagnosing ORA-4031 Error [Video] (Doc ID 396940.1)

http://www.bobbydurrettdba.com/2015/06/09/bug-13914613-example-shared-pool-latch-waits/

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s