{"id":415,"date":"2008-10-25T19:54:53","date_gmt":"2008-10-25T17:54:53","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=415"},"modified":"2010-10-25T23:02:31","modified_gmt":"2010-10-25T21:02:31","slug":"ora-600-be-careful-when-dynamically-resizing-sga-structures","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2008\/10\/25\/ora-600-be-careful-when-dynamically-resizing-sga-structures\/","title":{"rendered":"ORA-600 &#8211; be careful when dynamically resizing SGA structures"},"content":{"rendered":"<p>If you have Automatic Memory Management turned on (sga_target > 0) and you dynamically resize db_cache_size, you might &#8211; like me &#8211; encounter an instance crash with ORA-600 [Kmgs_pre_process_request_2].  <strong>Small change &#8211; big impact!<\/strong> Oracle tracks this problem with Bug 6597948 and Bug 5942310. There is a patch for HP-UX Itanium 10.2.0.3. It will be fixed in 10.2.0.5 and 11g. MetaLink Note 737458.1 gives more details.<\/p>\n<p>An even more obscure problem occurs when sga_target is set to an exact multiple of 4 GB: <b>Ora-600 [Kmgs_Pre_Process_Request_6] Terminates Instance When Resizing Caches<\/b>. See MetaLink 373802.1.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have Automatic Memory Management turned on (sga_target > 0) and you dynamically resize db_cache_size, you might &#8211; like me &#8211; encounter an instance crash with ORA-600 [Kmgs_pre_process_request_2]. Small change &#8211; big impact! Oracle tracks this problem with Bug 6597948 and Bug 5942310. There is a patch for HP-UX Itanium 10.2.0.3. It will be [&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,47,19,5],"tags":[],"class_list":["post-415","post","type-post","status-publish","format-standard","hentry","category-10g","category-bugs","category-metalink","category-oracle-database"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/415","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=415"}],"version-history":[{"count":6,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/415\/revisions"}],"predecessor-version":[{"id":919,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/415\/revisions\/919"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}