{"id":13352,"date":"2019-12-15T04:57:02","date_gmt":"2019-12-15T04:57:02","guid":{"rendered":"https:\/\/ittutorial.org\/?p=13352"},"modified":"2019-12-16T15:39:10","modified_gmt":"2019-12-16T15:39:10","slug":"oracle-database-19c-new-initialization-parameters","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-database-19c-new-initialization-parameters\/","title":{"rendered":"Oracle Database 19c New Initialization Parameters"},"content":{"rendered":"

The following initialization parameters are new in Oracle Database 19c:<\/p>\n

In Oracle 19c database Oracle introduced six parameters. We know that parameter plays very important role in database.<\/p>\n

 <\/p>\n

You can read the following article, if you don’t know how to install Oracle 19C….<\/p>\n

https:\/\/ittutorial.org\/oracle-database-19c-on-linux-7-6-step-by-step-installation-1\/<\/p>\n

DBAs should know the characteristics of all parameters which are in parameter files of the databases.<\/p>\n

ADG_REDIRECT_DML<\/strong>\r\n\r\nDATA_GUARD_MAX_IO_TIME<\/strong>\r\n\r\nDATA_GUARD_MAX_LONGIO_TIME<\/strong>\r\n\r\nENABLE_IMC_WITH_MIRA<\/strong>\r\n\r\nLOB_SIGNATURE_ENABLE<\/strong>\r\n\r\nMAX_DATAPUMP_PARALLEL_PER_JOB<\/strong><\/pre>\n
\u00a0<\/strong><\/p>\n
ADG_REDIRECT_DML\u00a0<\/strong><\/p>\n
This parameter enables DML redirection from Oracle Active Data Guard.<\/p>\n
Default Value           <\/strong>false<\/strong>\r\n\r\nModifiable \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ALTER SYSTEM<\/strong>\r\n\r\nModifiable in a PDB \u00a0 \u00a0 No<\/strong>\r\n\r\nRange of values \u00a0 \u00a0 \u00a0 \u00a0 true | false<\/strong>\r\n\r\nBasic \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 No<\/strong>\r\n\r\nOracle RAC\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Different instances can use different values.<\/strong><\/pre>\n
\u00a0<\/strong>\u00a0<\/strong><\/p>\n
DATA_GUARD_MAX_IO_TIME\u00a0<\/strong><\/p>\n
This parameter sets the maximum number of seconds that can elapse before a process is considered hung while performing a regular I\/O operation in an Oracle Data Guard environment. Regular I\/O operations include read, write, and status operations.<\/p>\n
Default Value<\/strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 240<\/strong>\r\n\r\nModifiable \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ALTER SYSTEM<\/strong>\r\n\r\nModifiable in a PDB \u00a0 \u00a0 \u00a0 \u00a0No<\/strong>\r\n\r\nRange of values \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a010 to 7200<\/strong>\r\n\r\nBasic \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0No<\/strong>\r\n\r\nOracle RAC \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Different instances can use different values.<\/strong><\/pre>\n
 <\/p>\n
DATA_GUARD_MAX_LONGIO_TIME\u00a0<\/strong><\/p>\n
This parameter sets the maximum number of seconds that can elapse before a process is considered hung while performing a long I\/O operation in an Oracle Data Guard environment. Long I\/O operations include open and close operations.<\/p>\n
Default Value<\/strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0240<\/strong>\r\n\r\nModifiable \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ALTER SYSTEM<\/strong>\r\n\r\nModifiable in a PDB \u00a0 \u00a0 \u00a0 No<\/strong>\r\n\r\nRange of values \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 10 to 7200<\/strong>\r\n\r\nBasic \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 No<\/strong>\r\n\r\nOracle RAC\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Different instances can use different values.<\/strong><\/pre>\n
\u00a0<\/strong><\/p>\n
\u00a0<\/strong>ENABLE_IMC_WITH_MIRA<\/strong><\/p>\n
This parameter enables or disables the In-Memory Column Store and Oracle Data Guard Multi-Instance Redo Apply, at the same time, on an Active Data Guard standby database.<\/p>\n
The value of this parameter is relevant only on the instance where MRP0 is spawned at the start of Redo Apply on a standby database.<\/p>\n
Default Value<\/strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  false<\/strong>\r\n\r\nModifiable \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ALTER SYSTEM<\/strong>\r\n\r\nModifiable in a PDB \u00a0 \u00a0 \u00a0 \u00a0 No<\/strong>\r\n\r\nRange of values \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 true | false<\/strong>\r\n\r\nBasic \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 No<\/strong>\r\n\r\nOracle RAC\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Different instances can use different values.<\/strong>\r\n\r\n\r\n<\/pre>\n
LOB_SIGNATURE_ENABLE<\/strong><\/p>\n
This parameter is used to enable or disable the LOB locator signature feature.<\/p>\n
You can secure your LOBs by enabling the LOB locator signature feature. A LOB locator is a pointer to the location of a large object (LOB) value.<\/p>\n
If the LOB_SIGNATURE_ENABLED\u00a0initialization parameter is set to\u00a0true, then when you create a LOB, Oracle Database automatically assigns a signature to the LOB locator.When Oracle Database receives a request from a client, it uses the signature to determine if any tampering with the LOB locator has occurred.When this parameter is set to\u00a0true, you also have the option of further securing your LOBs by encrypting your LOB locator signature keys.<\/p>\n
Default Value<\/strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0false<\/strong>\r\n\r\nModifiable \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ALTER SYSTEM<\/strong>\r\n\r\nModifiable in a PDB \u00a0 \u00a0 \u00a0 \u00a0 Yes<\/strong>\r\n\r\nRange of values \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 true | false<\/strong>\r\n\r\nBasic \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 No<\/strong>\r\n\r\nOracle RAC\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Multipile instances must have the same values.<\/strong>\r\n\r\n\r\n<\/pre>\n
MAX_DATAPUMP_PARALLEL_PER_JOB\u00a0<\/strong><\/p>\n
This parameter specifies the maximum number of parallel processes allowed per Oracle Data Pump job.<\/p>\n
When this parameter has a value of\u00a0AUTO, Oracle Data Pump derives its value to be 50 percent of the value of the\u00a0SESSIONS\u00a0initialization parameter.<\/p>\n
Syntax \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0MAX_DATAPUMP_PARALLEL_PER_JOB = { integer | AUTO }<\/strong>\r\n\r\nDefault Value<\/strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a050<\/strong>\r\n\r\nModifiable \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ALTER SYSTEM<\/strong>\r\n\r\nModifiable in a PDB \u00a0 \u00a0 \u00a0 \u00a0 Yes<\/strong>\r\n\r\nRange of values \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1 to 1024, or AUTO <\/strong>\r\n\r\nBasic \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 No<\/strong>\r\n\r\nOracle RAC\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Different instances can use different values.<\/strong>\r\n\r\n\r\n<\/pre>\n
Cheers!!!!<\/strong><\/p>\n
With Best Wishes!!!!<\/strong><\/p>\n
Ahmad<\/strong><\/p>\n
Oracle Consultant<\/strong><\/p>\n
OCS (12c GG)<\/strong><\/p>\n
OCE (11gR2 RAC)<\/strong><\/p>\n
OCP (11gR2\/10gR2\/9iR2)<\/strong><\/p>\n
OCA (9i R2)<\/strong><\/p>\n
Oracle Ride !!<\/strong><\/p>\n
 <\/p>\n
Reference–:http:\/\/www.oracle.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
The following initialization parameters are new in Oracle Database 19c: In Oracle 19c database Oracle introduced six parameters. We know that parameter plays very important role in database.   You can read the following article, if you don’t know how to install Oracle 19C…. https:\/\/ittutorial.org\/oracle-database-19c-on-linux-7-6-step-by-step-installation-1\/ DBAs should know the characteristics of all parameters which are …<\/p>\n","protected":false},"author":10456,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5047,5084,5044,1994],"tags":[7133,5217],"class_list":["post-13352","post","type-post","status-publish","format-standard","","category-architecture","category-dataguard","category-datapump","category-oracle","tag-initialization-parameters","tag-oracle-19c-database"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/10456"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=13352"}],"version-history":[{"count":15,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13352\/revisions"}],"predecessor-version":[{"id":13405,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13352\/revisions\/13405"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=13352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=13352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=13352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}