{"id":10368,"date":"2017-07-18T15:06:45","date_gmt":"2017-07-18T13:06:45","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/"},"modified":"2017-07-18T15:06:45","modified_gmt":"2017-07-18T13:06:45","slug":"recommended-db-parameters-on-the-oracle-database-appliance-oda","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/","title":{"rendered":"Recommended DB Parameters on the Oracle Database Appliance (ODA)"},"content":{"rendered":"<p>When creating a DB on the ODA using<\/p>\n<p><code><br \/>\n# oakcli create database -db &#060;db-name&#062;<br \/>\n<\/code><\/p>\n<p>a template is used to set a couple of DB parameters like e.g.<\/p>\n<p><code><br \/>\n_datafile_write_errors_crash_instance=FALSE<br \/>\n_db_writer_coalesce_area_size=16777216<br \/>\n_disable_interface_checking=TRUE<br \/>\n_ENABLE_NUMA_SUPPORT=FALSE<br \/>\n_FILE_SIZE_INCREASE_INCREMENT=2143289344<br \/>\n_gc_policy_time=0<br \/>\n_gc_undo_affinity=FALSE<br \/>\ndb_block_checking='FULL'<br \/>\ndb_block_checksum='FULL'<br \/>\ndb_lost_write_protect='TYPICAL'<br \/>\nfilesystemio_options='setall'<br \/>\nparallel_adaptive_multi_user=FALSE<br \/>\nparallel_execution_message_size=16384<br \/>\nparallel_threads_per_cpu=2<br \/>\nuse_large_pages='ONLY'<br \/>\n<\/code><\/p>\n<p>In recent projects I saw a couple of DBs running on ODA, which did not have (all) those parameters set, because the DBs were migrated from a non-ODA-platform and the customer took over the previous settings.<\/p>\n<p>The questions are: Are above parameters mandatory on ODA and where do I find them?<\/p>\n<p>Actually Oracle writes in the documentation<br \/>\nhttp:\/\/docs.oracle.com\/cd\/E83239_01\/doc.121\/e83201\/database-templates-oracle-database-appliance.htm#CMTAR269<\/p>\n<p>&#8220;Oracle strongly recommends that you use the Oracle Database Appliance templates, because they implement best practices and are configured specifically for Oracle Database Appliance.&#8221;<\/p>\n<p>So it&#8217;s not mandatory, but it&#8217;s &#8220;strongly recommended&#8221; by Oracle to set those parameters on ODA.<\/p>\n<p>The parameters are actually defined in the XML-files<br \/>\n<code><br \/>\n\/opt\/oracle\/oak\/onecmd\/templates\/OAK_oltp.dbt<br \/>\n\/opt\/oracle\/oak\/onecmd\/templates\/OAK_dss.dbt<br \/>\n<\/code><br \/>\nE.g. on a virtualized X5-2 HA with 12.1.2.8.0 installed:<\/p>\n<p><code><br \/>\n# grep \"initParam name\" \/opt\/oracle\/oak\/onecmd\/templates\/OAK_oltp.dbt<br \/>\n     &#060;initParam name=\"AUDIT_SYS_OPERATIONS\" value=\"TRUE\"\/&#062;<br \/>\n     &#060;initParam name=\"AUDIT_TRAIL\" value=\"DB\"\/&#062;<br \/>\n     &#060;initParam name=\"GLOBAL_NAMES\" value=\"TRUE\"\/&#062;<br \/>\n     &#060;initParam name=\"OS_AUTHENT_PREFIX\" value=\"\"\/&#062;<br \/>\n     &#060;initParam name=\"SQL92_SECURITY\" value=\"TRUE\"\/&#062;<br \/>\n     &#060;initParam name=\"PARALLEL_ADAPTIVE_MULTI_USER\" value=\"FALSE\"\/&#062;<br \/>\n     &#060;initParam name=\"PARALLEL_EXECUTION_MESSAGE_SIZE\" value=\"16384\"\/&#062;<br \/>\n     &#060;initParam name=\"PARALLEL_THREADS_PER_CPU\" value=\"2\"\/&#062;<br \/>\n     &#060;initParam name=\"_disable_interface_checking\" value=\"TRUE\"\/&#062;<br \/>\n     &#060;initParam name=\"_gc_undo_affinity\" value=\"FALSE\"\/&#062;<br \/>\n     &#060;initParam name=\"_gc_policy_time\" value=\"0\"\/&#062;<br \/>\n     &#060;initParam name=\"SESSION_CACHED_CURSORS\" value=\"100\"\/&#062;<br \/>\n     &#060;initParam name=\"OPEN_CURSORS\" value=\"1000\"\/&#062;<br \/>\n     &#060;initParam name=\"CURSOR_SHARING\" value=\"EXACT\"\/&#062;<br \/>\n     &#060;initParam name=\"_ENABLE_NUMA_SUPPORT\" value=\"FALSE\"\/&#062;<br \/>\n     &#060;initParam name=\"DB_LOST_WRITE_PROTECT\" value=\"TYPICAL\"\/&#062;<br \/>\n     &#060;initParam name=\"DB_BLOCK_CHECKSUM\" value=\"FULL\"\/&#062;<br \/>\n     &#060;initParam name=\"DB_BLOCK_CHECKING\" value=\"FULL\"\/&#062;<br \/>\n     &#060;initParam name=\"FAST_START_MTTR_TARGET\" value=\"300\"\/&#062;<br \/>\n     &#060;initParam name=\"UNDO_RETENTION\" value=\"900\"\/&#062;<br \/>\n     &#060;initParam name=\"_FILE_SIZE_INCREASE_INCREMENT\" value=\"2143289344\"\/&#062;<br \/>\n     &#060;initParam name=\"FILESYSTEMIO_OPTIONS\" value=\"setall\"\/&#062;<br \/>\n     &#060;initParam name=\"use_large_pages\" value=\"only\"\/&#062;<br \/>\n     &#060;initParam name=\"DB_FILES\" value=\"1024\"\/&#062;<br \/>\n     &#060;initParam name=\"processes\" value=\"4800\"\/&#062;<br \/>\n     &#060;initParam name=\"pga_aggregate_target\" value=\"49152\" unit=\"MB\"\/&#062;<br \/>\n     &#060;initParam name=\"sga_target\" value=\"98304\" unit=\"MB\"\/&#062;<br \/>\n     &#060;initParam name=\"db_create_file_dest\" value=\"+DATA\"\/&#062;<br \/>\n     &#060;initParam name=\"log_buffer\" value=\"64000000\" \/&#062;<br \/>\n     &#060;initParam name=\"cpu_count\" value=\"48\"\/&#062;<br \/>\n     &#060;initParam name=\"pga_aggregate_limit\" value=\"49152\" unit=\"MB\"\/&#062;<br \/>\n     &#060;initParam name=\"_datafile_write_errors_crash_instance\" value=\"false\"\/&#062;<br \/>\n     &#060;initParam name=\"_fix_control\" value=\"18960760:on\"\/&#062;<br \/>\n     &#060;initParam name=\"db_block_size\" value=\"8\" unit=\"KB\"\/&#062;<br \/>\n     &#060;initParam name=\"compatible\" value=\"11.2.0.x.0\"\/&#062;<br \/>\n     &#060;initParam name=\"undo_tablespace\" value=\"UNDOTBS1\"\/&#062;<br \/>\n     &#060;initParam name=\"control_files\" value=\"(&quot;{ORACLE_BASE}\/oradata\/{DB_UNIQUE_NAME}\/control01.ctl&quot;)\"\/&#062;<br \/>\n     &#060;initParam name=\"audit_file_dest\" value=\"{ORACLE_BASE}\/admin\/{DB_UNIQUE_NAME}\/adump\"\/&#062;<br \/>\n     &#060;initParam name=\"audit_trail\" value=\"db\"\/&#062;<br \/>\n     &#060;initParam name=\"diagnostic_dest\" value=\"{ORACLE_BASE}\"\/&#062;<br \/>\n     &#060;initParam name=\"remote_login_passwordfile\" value=\"EXCLUSIVE\"\/&#062;<br \/>\n     &#060;initParam name=\"dispatchers\" value=\"(PROTOCOL=TCP) (SERVICE={SID}XDB)\"\/&#062;<br \/>\n     &#060;initParam name=\"db_recovery_file_dest\" value=\"+RECO\"\/&#062;<br \/>\n     &#060;initParam name=\"db_recovery_file_dest_size\" value=\"1843200\" unit=\"MB\"\/&#062;<br \/>\n     &#060;initParam name=\"db_create_online_log_dest_1\" value=\"+REDO\" \/&#062;<br \/>\n     &#060;initParam name=\"_db_writer_coalesce_area_size\" value=\"16777216\"\/&#062;<br \/>\n<\/code><\/p>\n<p>Oracle does not take those parameters blindly when creating a DB with oakcli, but adjusts them as e.g. described in the Blog <\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"CCQWsajo04\"><p><a href=\"https:\/\/www.dbi-services.com\/blog\/oda-32gb-template-but-got-a-database-with-16gb-sga\/\">ODA \u2013 32GB template but got a database with 16GB SGA???<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;ODA \u2013 32GB template but got a database with 16GB SGA???&#8221; &#8212; dbi Blog\" src=\"https:\/\/www.dbi-services.com\/blog\/oda-32gb-template-but-got-a-database-with-16gb-sga\/embed\/#?secret=rvWz1PqGTm#?secret=CCQWsajo04\" data-secret=\"CCQWsajo04\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><br \/>\nI.e. the SGA_TARGET and PGA_AGGREGATE_TARGET parameters are adjusted based on the chosen database class. Also the COMPATIBLE-parameter is set to the current release (e.g. to 12.1.0.2.0).<\/p>\n<p>So if you&#8217;re not able to create the DB on ODA using<br \/>\n<code><br \/>\n# oakcli create database -db &#060;db-name&#062;<br \/>\n<\/code><br \/>\nthen I recommend to check the XML-file OAK_oltp.dbt (or in case of a Decision Support System\/Warehouse-DB the file OAK_dss.dbt) and set the parameters in your database accordingly. Alternatively (and probably even better) you may create a dummy-DB using oakcli and check Oracle&#8217;s settings, which can then be used in your migrated DB, and drop the dummy-DB afterwards.<\/p>\n<p>Here the parameters of a 12c-DB created on a virtualized ODA X6-2 HA 12.1.2.11.0 with oakcli create database using the smallest setting with 1 Core and the DSS-template:<\/p>\n<p><code><br \/>\n*._datafile_write_errors_crash_instance=false<br \/>\n*._db_writer_coalesce_area_size=16777216<br \/>\n*._disable_interface_checking=TRUE<br \/>\n*._ENABLE_NUMA_SUPPORT=FALSE<br \/>\n*._FILE_SIZE_INCREASE_INCREMENT=2143289344<br \/>\n*._fix_control='18960760:on'<br \/>\n*._gc_policy_time=0<br \/>\n*._gc_undo_affinity=FALSE<br \/>\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/C12TEST\/adump'<br \/>\n*.audit_sys_operations=TRUE<br \/>\n*.audit_trail='db'<br \/>\n*.cluster_database=true<br \/>\n*.compatible='12.1.0.2.0'<br \/>\n*.control_files='\/u01\/app\/oracle\/oradata\/datastore\/C12TEST\/C12TEST\/controlfile\/o1_mf_dpw4ljnv_.ctl'<br \/>\n*.cpu_count=2<br \/>\n*.cursor_sharing='EXACT'<br \/>\n*.db_block_checking='FULL'<br \/>\n*.db_block_checksum='FULL'<br \/>\n*.db_block_size=8192<br \/>\n*.db_create_file_dest='\/u02\/app\/oracle\/oradata\/datastore\/.ACFS\/snaps\/C12TEST'<br \/>\n*.db_create_online_log_dest_1='\/u01\/app\/oracle\/oradata\/datastore\/C12TEST'<br \/>\n*.db_domain=''<br \/>\n*.db_files=1024<br \/>\n*.db_lost_write_protect='TYPICAL'<br \/>\n*.db_name='C12TEST'<br \/>\n*.db_recovery_file_dest='\/u01\/app\/oracle\/fast_recovery_area\/datastore\/C12TEST'<br \/>\n*.db_recovery_file_dest_size=476160m<br \/>\n*.diagnostic_dest='\/u01\/app\/oracle'<br \/>\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=C12TESTXDB)'<br \/>\n*.fast_start_mttr_target=300<br \/>\n*.filesystemio_options='setall'<br \/>\n*.global_names=TRUE<br \/>\n*.inmemory_size=0m<br \/>\n*.log_archive_format='%t_%s_%r.dbf'<br \/>\n*.log_buffer=16000000<br \/>\n*.nls_language='AMERICAN'<br \/>\n*.nls_territory='AMERICA'<br \/>\n*.open_cursors=1000<br \/>\n*.os_authent_prefix=''<br \/>\n*.parallel_adaptive_multi_user=TRUE<br \/>\n*.parallel_degree_policy='MANUAL'<br \/>\n*.parallel_execution_message_size=16384<br \/>\n*.parallel_force_local=FALSE<br \/>\n*.parallel_max_servers=80<br \/>\n*.parallel_min_servers=8<br \/>\n*.parallel_threads_per_cpu=2<br \/>\n*.pga_aggregate_limit=2048m<br \/>\n*.pga_aggregate_target=2048m<br \/>\n*.processes=200<br \/>\n*.remote_login_passwordfile='exclusive'<br \/>\n*.session_cached_cursors=100<br \/>\n*.sga_target=1024m<br \/>\n*.sql92_security=TRUE<br \/>\n*.undo_retention=900<br \/>\n*.use_large_pages='ONLY'<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When creating a DB on the ODA using # oakcli create database -db &#060;db-name&#062; a template is used to set a couple of DB parameters like e.g. _datafile_write_errors_crash_instance=FALSE _db_writer_coalesce_area_size=16777216 _disable_interface_checking=TRUE _ENABLE_NUMA_SUPPORT=FALSE _FILE_SIZE_INCREASE_INCREMENT=2143289344 _gc_policy_time=0 _gc_undo_affinity=FALSE db_block_checking=&#8217;FULL&#8217; db_block_checksum=&#8217;FULL&#8217; db_lost_write_protect=&#8217;TYPICAL&#8217; filesystemio_options=&#8217;setall&#8217; parallel_adaptive_multi_user=FALSE parallel_execution_message_size=16384 parallel_threads_per_cpu=2 use_large_pages=&#8217;ONLY&#8217; In recent projects I saw a couple of DBs running on ODA, which [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,199,59],"tags":[79,96,365],"type_dbi":[],"class_list":["post-10368","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-hardware-storage","category-oracle","tag-oda","tag-oracle","tag-oracle-database-appliance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Recommended DB Parameters on the Oracle Database Appliance (ODA) - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recommended DB Parameters on the Oracle Database Appliance (ODA)\" \/>\n<meta property=\"og:description\" content=\"When creating a DB on the ODA using # oakcli create database -db &#060;db-name&#062; a template is used to set a couple of DB parameters like e.g. _datafile_write_errors_crash_instance=FALSE _db_writer_coalesce_area_size=16777216 _disable_interface_checking=TRUE _ENABLE_NUMA_SUPPORT=FALSE _FILE_SIZE_INCREASE_INCREMENT=2143289344 _gc_policy_time=0 _gc_undo_affinity=FALSE db_block_checking=&#039;FULL&#039; db_block_checksum=&#039;FULL&#039; db_lost_write_protect=&#039;TYPICAL&#039; filesystemio_options=&#039;setall&#039; parallel_adaptive_multi_user=FALSE parallel_execution_message_size=16384 parallel_threads_per_cpu=2 use_large_pages=&#039;ONLY&#039; In recent projects I saw a couple of DBs running on ODA, which [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-18T13:06:45+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Recommended DB Parameters on the Oracle Database Appliance (ODA)\",\"datePublished\":\"2017-07-18T13:06:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/\"},\"wordCount\":323,\"commentCount\":0,\"keywords\":[\"ODA\",\"Oracle\",\"Oracle database appliance\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"Hardware &amp; Storage\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/\",\"name\":\"Recommended DB Parameters on the Oracle Database Appliance (ODA) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-07-18T13:06:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recommended DB Parameters on the Oracle Database Appliance (ODA)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Recommended DB Parameters on the Oracle Database Appliance (ODA) - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/","og_locale":"en_US","og_type":"article","og_title":"Recommended DB Parameters on the Oracle Database Appliance (ODA)","og_description":"When creating a DB on the ODA using # oakcli create database -db &#060;db-name&#062; a template is used to set a couple of DB parameters like e.g. _datafile_write_errors_crash_instance=FALSE _db_writer_coalesce_area_size=16777216 _disable_interface_checking=TRUE _ENABLE_NUMA_SUPPORT=FALSE _FILE_SIZE_INCREASE_INCREMENT=2143289344 _gc_policy_time=0 _gc_undo_affinity=FALSE db_block_checking='FULL' db_block_checksum='FULL' db_lost_write_protect='TYPICAL' filesystemio_options='setall' parallel_adaptive_multi_user=FALSE parallel_execution_message_size=16384 parallel_threads_per_cpu=2 use_large_pages='ONLY' In recent projects I saw a couple of DBs running on ODA, which [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/","og_site_name":"dbi Blog","article_published_time":"2017-07-18T13:06:45+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Recommended DB Parameters on the Oracle Database Appliance (ODA)","datePublished":"2017-07-18T13:06:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/"},"wordCount":323,"commentCount":0,"keywords":["ODA","Oracle","Oracle database appliance"],"articleSection":["Database Administration &amp; Monitoring","Database management","Hardware &amp; Storage","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/","url":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/","name":"Recommended DB Parameters on the Oracle Database Appliance (ODA) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-07-18T13:06:45+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/recommended-db-parameters-on-the-oracle-database-appliance-oda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Recommended DB Parameters on the Oracle Database Appliance (ODA)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10368"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10368\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10368"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}