{"id":926,"date":"2009-04-08T15:27:45","date_gmt":"2009-04-08T23:27:45","guid":{"rendered":"http:\/\/blogs.pugetsound.edu\/TSmaintenance\/?p=926"},"modified":"2009-04-08T15:27:45","modified_gmt":"2009-04-08T23:27:45","slug":"mil9ip-instance-performance-truning","status":"publish","type":"post","link":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/2009\/04\/08\/mil9ip-instance-performance-truning\/","title":{"rendered":"Mil9ip Instance Performance Tuning"},"content":{"rendered":"<p>Performed Mil9ip tuning on 4\/7\/2008, based the test on mildemo instance with Sean Vincent.\u00a0 According to Sean, this tuning improved the performance of Millennium dramatically.\u00a0 The tuning includes the follwing changes in the parameter file.<\/p>\n<p style=\"margin-left: 0.5in;text-indent: -0.25in\"><span style=\"font-size: 10pt;font-family: Symbol\"><span>\u00b7<span style=\"font: 7pt 'Times New Roman'\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt;font-family: Gulim\">optimizer_mode=FIRST_ROWS from CHOOSE<\/span><\/p>\n<p style=\"margin-left: 0.5in;text-indent: -0.25in\"><span style=\"font-size: 10pt;font-family: Symbol\"><span>\u00b7<span style=\"font: 7pt 'Times New Roman'\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><span style=\"font-size: 10pt;font-family: Gulim\">increased shared_pool_size, pga_aggregate_target size, and sga_max_size<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Performed Mil9ip tuning on 4\/7\/2008, based the test on mildemo instance with Sean Vincent.\u00a0 According to Sean, this tuning improved the performance of Millennium dramatically.\u00a0 The tuning includes the follwing changes in the parameter file. \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 optimizer_mode=FIRST_ROWS from CHOOSE \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &hellip; <a href=\"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/2009\/04\/08\/mil9ip-instance-performance-truning\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[62],"class_list":["post-926","post","type-post","status-publish","format-standard","hentry","category-millenium","tag-add-new-tag"],"_links":{"self":[{"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/posts\/926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/comments?post=926"}],"version-history":[{"count":0,"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/posts\/926\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/media?parent=926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/categories?post=926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.pugetsound.edu\/tsmaintenance\/wp-json\/wp\/v2\/tags?post=926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}