IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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
