Oracle PGA

这两天读了一下jonathan lewis大师的https://jonathanlewis.wordpress.com/2009/06/07/pga-leaks/这篇文章,然后延伸的一下读了下其他与Oracle内存相关的blog和MOS文章,做了一些实验,这里记录一下比较好的文章链接,后续google到其他文章进行后续更新。

Joze Senegacnik的Senegacnik_PGAMemoryManagement_Oracle9i_10g_clanek.pdf

https://jonathanlewis.wordpress.com/2007/12/19/memory-management/

https://jonathanlewis.wordpress.com/2010/06/23/memory/

https://jonathanlewis.wordpress.com/2014/10/13/memory-2/

https://dioncho.wordpress.com/2009/06/09/707/

https://www.pythian.com/blog/pythian-goodies-free-memory-swap-oracle-and-everything/#

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:17748700346068277#1769649200346012017

http://sites.google.com/site/ukja/sql-scripts-1/c/heap_analyze

dioncho使用PL/SQL写个了分析heapdump的heap_analyzertanel poderheapdump_analyzer也是分析heap dump的好帮手。

 

Oracle Mos Id:

Bug 5866410 – PLSQL BULK insert consumes a lot of PGA memory (Doc ID 5866410.8)

Automatic PGA Memory Management (Doc ID 223730.1)

Excessive PGA memory or ORA-4030 using PLSQL BULK FORALL insert (Doc ID 1266481.1)

 

 

 

 

此条目发表在Memory分类目录。将固定链接加入收藏夹。

发表评论

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 / 更改 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s