{"id":125,"date":"2009-05-21T21:37:58","date_gmt":"2009-05-22T02:37:58","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=125"},"modified":"2011-07-06T09:55:34","modified_gmt":"2011-07-06T14:55:34","slug":"setting-a-parameter-in-another-session","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2009\/05\/21\/setting-a-parameter-in-another-session\/","title":{"rendered":"Setting a parameter in another session"},"content":{"rendered":"<p>Today I needed to set the optimizer_dynamic_sampling in several sessions to a lower value.  It was set to 5, which is <strong>way<\/strong> too high for this application.<\/p>\n<p>I used what is below.<\/p>\n<pre>begin\r\n  for cur in (select sid,serial# from v$session where action like 'DRAIN%') loop\r\n    sys.dbms_system.set_int_param_in_session(cur.sid,cur.serial#,'optimizer_dynamic_sampling',2);\r\n  end loop;\r\nend;\r\n\/<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Today I needed to set the optimizer_dynamic_sampling in several sessions to a lower value. It was set to 5, which is way too high for this application. I used what is below. begin for cur in (select sid,serial# from v$session&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2009\/05\/21\/setting-a-parameter-in-another-session\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/125"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=125"}],"version-history":[{"count":8,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/125\/revisions"}],"predecessor-version":[{"id":1306,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/125\/revisions\/1306"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=125"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}