Before configuring services for Transaction Guard, use the following configuration checklist:
Grant permission to the application user who will call GET_LTXID_OUTCOME, as follows:
GRANT EXECUTE ON DBMS_APP_CONT to user_name;
Locate and define the transaction history table for optimal performance.
The transaction history table (LTXID_HIST) is created, by default, in the SYSAUX tablespace when you create or upgrade an Oracle Database. New partitions are added when you add instances, using the storage of the last partition. If the ___location of transaction history table is not optimal for performance, then you can move it to another tablespace and create partitions there. For example, the following statement moves the transaction history table to a tablespace named FastPace:
ALTER TABLE LTXID_TRANS move partition LTXID_TRANS_1 tablespace FastPace storage ( initial 10G next 10G minextents 1 maxextents 121 );
Set values for the -commit_outcome and -retention_timeout service parameters.
If you are using Oracle RAC, Oracle Data Guard, or Oracle Active Data Guard, then Oracle recommends that you use FAN for fast notification of an outage.