{"id":985,"date":"2015-07-23T13:25:32","date_gmt":"2015-07-23T17:25:32","guid":{"rendered":"http:\/\/shirishranjit.com\/blog1\/?page_id=985"},"modified":"2023-02-23T09:22:13","modified_gmt":"2023-02-23T14:22:13","slug":"oracle-database-optimizations-for-high-throughput","status":"publish","type":"page","link":"https:\/\/shirishranjit.com\/blog1\/big-data\/oracle-database-optimizations-for-high-throughput","title":{"rendered":"Oracle Database Optimizations for High Throughput"},"content":{"rendered":"<p>OPTIMIZER_INDEX_COST_ADJ changed from 100 to 10<br \/>\nIncreased PGA size from 4G to 15G<br \/>\nDisabled the direct path read ( init.ora: event = &#8220;10949 trace name context forever&#8217;)<br \/>\nconfigured cursor sharing parameter as force earlier it was &#8216;EXACT&#8217;<\/p>\n<p>FILESYSTEMIO_OPTIONS=SETALL as of now &#8216;NONE&#8217;<br \/>\nConfigure Huges pages<br \/>\nBreak the mirroring of log files.<br \/>\nCreation of indexes<br \/>\nIncrease SGA Size<\/p>\n<p>&nbsp;<\/p>\n<p>References:<\/p>\n<ul>\n<li>Advance JDBC topics:&nbsp;<a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e12137\/addfunc.htm#TDPJD206\">http:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e12137\/addfunc.htm#TDPJD206<\/a><\/li>\n<li>Ref Cursor and JDBC:&nbsp;<a href=\"http:\/\/docs.oracle.com\/cd\/A87860_01\/doc\/java.817\/a83724\/samapp5.htm\">http:\/\/docs.oracle.com\/cd\/A87860_01\/doc\/java.817\/a83724\/samapp5.htm<\/a><\/li>\n<\/ul>\n<div class=\"twttr_buttons\"><div class=\"twttr_twitter\">\n\t\t\t\t\t<a href=\"http:\/\/twitter.com\/share?text=Oracle+Database+Optimizations+for+High+Throughput\" class=\"twitter-share-button\" data-via=\"\" data-hashtags=\"\"  data-size=\"default\" data-url=\"https:\/\/shirishranjit.com\/blog1\/big-data\/oracle-database-optimizations-for-high-throughput\"  data-related=\"\" target=\"_blank\">Tweet<\/a>\n\t\t\t\t<\/div><div class=\"twttr_followme\">\n\t\t\t\t\t\t<a href=\"https:\/\/twitter.com\/shiranjit\" class=\"twitter-follow-button\" data-size=\"default\"  data-show-screen-name=\"false\"  target=\"_blank\">Follow me<\/a>\n\t\t\t\t\t<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>OPTIMIZER_INDEX_COST_ADJ changed from 100 to 10 Increased PGA size from 4G to 15G Disabled the direct path read ( init.ora: event = &#8220;10949 trace name context forever&#8217;) configured cursor sharing parameter as force earlier it was &#8216;EXACT&#8217; FILESYSTEMIO_OPTIONS=SETALL as of &hellip; <a href=\"https:\/\/shirishranjit.com\/blog1\/big-data\/oracle-database-optimizations-for-high-throughput\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":396,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-985","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages\/985"}],"collection":[{"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/comments?post=985"}],"version-history":[{"count":4,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages\/985\/revisions"}],"predecessor-version":[{"id":2240,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages\/985\/revisions\/2240"}],"up":[{"embeddable":true,"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/pages\/396"}],"wp:attachment":[{"href":"https:\/\/shirishranjit.com\/blog1\/wp-json\/wp\/v2\/media?parent=985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}