{"id":146,"date":"2019-08-13T18:28:09","date_gmt":"2019-08-13T18:28:09","guid":{"rendered":"http:\/\/redmine\/wordpress\/?page_id=146"},"modified":"2022-07-30T08:56:07","modified_gmt":"2022-07-30T08:56:07","slug":"database-konfiguration","status":"publish","type":"page","link":"https:\/\/www.berg-consult.dk\/en\/database-konfiguration","title":{"rendered":"Database configuration"},"content":{"rendered":"<div id=\"wp-block-themeisle-blocks-advanced-columns-f4be9de1\" class=\"wp-block-themeisle-blocks-advanced-columns has-2-columns has-desktop-equal-layout has-tablet-equal-layout has-mobile-collapsedRows-layout has-vertical-unset\"><div class=\"wp-block-themeisle-blocks-advanced-columns-overlay\"><\/div><div class=\"innerblocks-wrap\">\n<div id=\"wp-block-themeisle-blocks-advanced-column-2df41fb1\" class=\"wp-block-themeisle-blocks-advanced-column\">\n<p>Configuring a database for performance encompasses activities as configuration of the physical layout and setting the database parameters.<\/p>\n\n\n\n<p>For the Oracle Database it is only a subset of all the database parameters, that influences the performance.<\/p>\n\n\n\n<p>A pristine Oracle database will have most of the significant database parameters configured by default to support a wide range of usage patterns.<\/p>\n\n\n\n<p>Above statements is supported by the fact that many \u2013 often smaller systems \u2013 does not gain any significant improvements by changing database parameters after creation.<\/p>\n\n\n\n<p>Another way of stating above: There are no performance related database parameters what per default are wrongly configured.<\/p>\n\n\n\n<p>To determine whether performance can be improved by changing database parameters requires an analysis of the specific database usage and load.<\/p>\n<\/div>\n\n\n\n<div id=\"wp-block-themeisle-blocks-advanced-column-b4512ff6\" class=\"wp-block-themeisle-blocks-advanced-column\">\n<p>Martin Berg Consult has great expertise in configuring the database parameters to match the specific usage of the database<\/p>\n\n\n\n<p>The foundation for this will be an analysis of how the time is spend in the database processing SQL requests.<\/p>\n\n\n\n<p>With this knowlegde about the time usage a plan for recommended parameter changes can be described \u2013 with rationales.<\/p>\n<\/div>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"class_list":["post-146","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/www.berg-consult.dk\/en\/wp-json\/wp\/v2\/pages\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.berg-consult.dk\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.berg-consult.dk\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.berg-consult.dk\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.berg-consult.dk\/en\/wp-json\/wp\/v2\/comments?post=146"}],"version-history":[{"count":2,"href":"https:\/\/www.berg-consult.dk\/en\/wp-json\/wp\/v2\/pages\/146\/revisions"}],"predecessor-version":[{"id":576,"href":"https:\/\/www.berg-consult.dk\/en\/wp-json\/wp\/v2\/pages\/146\/revisions\/576"}],"wp:attachment":[{"href":"https:\/\/www.berg-consult.dk\/en\/wp-json\/wp\/v2\/media?parent=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}