rakshay (Customer) to rsaSFDCadmin (RSA): asked a question.
temp_undo_enabled on Oracle 19c
Hi,
I installed the [RSA IGL Recipes : System Health Check
Dashboard](https://community.rsa.com/t5/securid-governance-lifecycle/rsa-igl-
recipes-system-health-check-dashboard/m-p/570569#U570569) on a system running
IG&L v 7.5.2 patch3, with a client-supplied DB running Oracle version 19c
I see a recommendation to **set temp_undo_enable** to **True.**
I could not find any reference to this parameter in [SecurID Governance &
Lifecycle 7.5.2 Database Setup and Management
Guide](https://community.rsa.com/t5/securid-governance-lifecycle/securid-
governance-amp-lifecycle-7-5-2-database-setup-and/m-p/654444#U654444)
I did find [Oracle 12c TEMP_UNDO_ENABLED parameter for managing GTT UNDO
activity in RSA Identity Governance &
Lifecycle](https://community.rsa.com/t5/securid-governance-
lifecycle/oracle-12c-temp-undo-enabled-parameter-for-managing-gtt-
undo/m-p/1561#U1561) where the recommendation was to enable this parameter -
however this is for DB version 12c
One more interesting point: Oracle
[documentation](https://docs.oracle.com/en/database/oracle/oracle-
database/19/refrn/TEMP_UNDO_ENABLED.html#GUID-E2A01A84-2D63-401F-B64E-C96B18C5DCA6)
states
"When `TEMP_UNDO_ENABLED` is set to `true` and the COMPATIBLE initialization
parameter is set to `12.0.0`, this feature is enabled."
I guess this means this mechanism is no longer in use by IG&L on version 19c?
can you confirm the correct value for temp_undo_enabled on DB version 19c is
"false" ?
Thanks,
-Shay
I installed the [RSA IGL Recipes : System Health Check
Dashboard](https://community.rsa.com/t5/securid-governance-lifecycle/rsa-igl-
recipes-system-health-check-dashboard/m-p/570569#U570569) on a system running
IG&L v 7.5.2 patch3, with a client-supplied DB running Oracle version 19c
I see a recommendation to **set temp_undo_enable** to **True.**
I could not find any reference to this parameter in [SecurID Governance &
Lifecycle 7.5.2 Database Setup and Management
Guide](https://community.rsa.com/t5/securid-governance-lifecycle/securid-
governance-amp-lifecycle-7-5-2-database-setup-and/m-p/654444#U654444)
I did find [Oracle 12c TEMP_UNDO_ENABLED parameter for managing GTT UNDO
activity in RSA Identity Governance &
Lifecycle](https://community.rsa.com/t5/securid-governance-
lifecycle/oracle-12c-temp-undo-enabled-parameter-for-managing-gtt-
undo/m-p/1561#U1561) where the recommendation was to enable this parameter -
however this is for DB version 12c
One more interesting point: Oracle
[documentation](https://docs.oracle.com/en/database/oracle/oracle-
database/19/refrn/TEMP_UNDO_ENABLED.html#GUID-E2A01A84-2D63-401F-B64E-C96B18C5DCA6)
states
"When `TEMP_UNDO_ENABLED` is set to `true` and the COMPATIBLE initialization
parameter is set to `12.0.0`, this feature is enabled."
I guess this means this mechanism is no longer in use by IG&L on version 19c?
can you confirm the correct value for temp_undo_enabled on DB version 19c is
"false" ?
Thanks,
-Shay
TEMP_UNDO_ENABLE to TRUE:
[Oracle 12c TEMP_UNDO_ENABLED parameter for managing GTT UNDO activity in RSA
Identity Governance & Lifecycle](https://community.rsa.com/t5/securid-
governance-lifecycle/oracle-12c-temp-undo-enabled-parameter-for-managing-gtt-
undo/ta-p/1561)