{"id":372,"date":"2008-10-19T17:03:45","date_gmt":"2008-10-19T15:03:45","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=372"},"modified":"2008-10-19T17:03:45","modified_gmt":"2008-10-19T15:03:45","slug":"pga-management-in-oracle-10gr2","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2008\/10\/19\/pga-management-in-oracle-10gr2\/","title":{"rendered":"PGA Management in Oracle 10gR2"},"content":{"rendered":"<p>When researching PGA utilization on 10gR2, I collected a couple of important facts for automatic pga management:<\/p>\n<p><strong>Parameters (partially hidden)<br \/>\n<\/strong><\/p>\n<ul>\n<li> pga_aggregate_target: total physical memory for all workareas of all processes system-wide<\/li>\n<li>_smm_max_size: limit for single work area<\/li>\n<li>_pga_max_size: limit for single process<\/li>\n<li>_smm_px_max_size: limit for all parallel slaves of one workarea<\/li>\n<\/ul>\n<p><strong>pga_aggregate_target:<\/strong><\/p>\n<ul>\n<li> if p_a_t\u00a0 &lt;= 500 MB, then _smm_max_size = 20% of p_a_t<\/li>\n<li>if p_a_t\u00a0 between 500 and 1000 MB, then _smm_max_size = 100 MB<\/li>\n<li>if p_a_t &gt;= 1000 MB, then _smm_max_size = 10% of p_a_t<\/li>\n<\/ul>\n<p><strong>_pga_max_size:<\/strong><\/p>\n<ul>\n<li>_pga_max_size = 2 *\u00a0 _smm_max_size<\/li>\n<\/ul>\n<p><strong>_smm_px_max_size:<\/strong><\/p>\n<ul>\n<li>_smm_px_max_size = 50% PAT<\/li>\n<li>degree of parallelism (dop) &lt;= 5, then _smm_max_size is used for parallel slaves instead of smm_px_max_size<\/li>\n<li>degree of parallelism (dop) &gt; 5, then _smm_px_max_size\/DOP is used<\/li>\n<\/ul>\n<p>References:<\/p>\n<p><a href=\"http:\/\/www.sloug.org\/presentations\/If_Memory_Richmond_Shee.ppt\">Richmond Shee: If your memory serves you right<\/a><\/p>\n<p><a href=\"http:\/\/www.pythian.com\/documents\/Working_with_Automatic_PGA.ppt\">The Pythian Group: Working with Automatic PGA<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When researching PGA utilization on 10gR2, I collected a couple of important facts for automatic pga management: Parameters (partially hidden) pga_aggregate_target: total physical memory for all workareas of all processes system-wide _smm_max_size: limit for single work area _pga_max_size: limit for single process _smm_px_max_size: limit for all parallel slaves of one workarea pga_aggregate_target: if p_a_t\u00a0 &lt;= [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13,5],"tags":[],"class_list":["post-372","post","type-post","status-publish","format-standard","hentry","category-10g","category-oracle-database"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=372"}],"version-history":[{"count":7,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/372\/revisions"}],"predecessor-version":[{"id":379,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/372\/revisions\/379"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}