Site icon IT Tutorial

Oracle Database 19c New Initialization Parameters

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 in parameter files of the databases.

ADG_REDIRECT_DML

DATA_GUARD_MAX_IO_TIME

DATA_GUARD_MAX_LONGIO_TIME

ENABLE_IMC_WITH_MIRA

LOB_SIGNATURE_ENABLE

MAX_DATAPUMP_PARALLEL_PER_JOB

 

ADG_REDIRECT_DML 

This parameter enables DML redirection from Oracle Active Data Guard.

Default Value           false

Modifiable              ALTER SYSTEM

Modifiable in a PDB     No

Range of values         true | false

Basic                   No

Oracle RAC              Different instances can use different values.

  

DATA_GUARD_MAX_IO_TIME 

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.

Default Value              240

Modifiable                 ALTER SYSTEM

Modifiable in a PDB        No

Range of values            10 to 7200

Basic                      No

Oracle RAC                 Different instances can use different values.

 

DATA_GUARD_MAX_LONGIO_TIME 

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.

Default Value             240

Modifiable                ALTER SYSTEM

Modifiable in a PDB       No

Range of values           10 to 7200

Basic                     No

Oracle RAC                Different instances can use different values.

 

 ENABLE_IMC_WITH_MIRA

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.

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.

Default Value               false

Modifiable                  ALTER SYSTEM

Modifiable in a PDB         No

Range of values             true | false

Basic                       No

Oracle RAC                  Different instances can use different values.


LOB_SIGNATURE_ENABLE

This parameter is used to enable or disable the LOB locator signature feature.

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.

If the LOB_SIGNATURE_ENABLED initialization parameter is set to true, 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 true, you also have the option of further securing your LOBs by encrypting your LOB locator signature keys.

Default Value               false

Modifiable                  ALTER SYSTEM

Modifiable in a PDB         Yes

Range of values             true | false

Basic                       No

Oracle RAC                  Multipile instances must have the same values.


MAX_DATAPUMP_PARALLEL_PER_JOB 

This parameter specifies the maximum number of parallel processes allowed per Oracle Data Pump job.

When this parameter has a value of AUTO, Oracle Data Pump derives its value to be 50 percent of the value of the SESSIONS initialization parameter.

Syntax                      MAX_DATAPUMP_PARALLEL_PER_JOB = { integer | AUTO }

Default Value               50

Modifiable                  ALTER SYSTEM

Modifiable in a PDB         Yes

Range of values             1 to 1024, or AUTO 

Basic                       No

Oracle RAC                  Different instances can use different values.


Cheers!!!!

With Best Wishes!!!!

Ahmad

Oracle Consultant

OCS (12c GG)

OCE (11gR2 RAC)

OCP (11gR2/10gR2/9iR2)

OCA (9i R2)

Oracle Ride !!

 

Reference–:http://www.oracle.com

Exit mobile version