You can use an additional setting to set the rules for the Oracle optimizer_mode feature. This additional setting determines the rules for the use of the 'alter session set optimizer mode=RULE’ SQL statement for RMAN. This can help improve the performance of RMAN procedures.
By default, the software adds the 'alter session set optimizer mode=RULE' statement to the RMAN scripts for Oracle 10gR2 clients.
When you set the additional setting to 'Y', the software adds the 'alter session set optimizer mode=RULE' statement to the RMAN scripts for Oracle 10gR2, 11gR2 and 12c clients.
When you set the additional setting to 'N', the software does not add the 'alter session set optimizer mode=RULE' statement to the RMAN scripts for any client.
Procedure
- To the client computer, add the sRMANOPTPERFFIX additional setting as shown in the following table.
|
Property |
Value |
|---|---|
|
Name |
|
|
Category |
OracleAgent |
|
Type |
String |
|
Value |
Y |