Problem Diagnosis - Expert Oracle RAC Performance Diagnostics and Tuning - page 615

These values can be modified using ADR command line interface or using the EM. To modify these parameters
using command line interface, the following steps are the followed:

adrci> show control
ADR Home = /app/oracle/diag/rdbms/prddb/PRDDB_1:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME
-----------------------------------------------------------------------------------------
2673816947 720 8760 2010-08-21 19:44:43.295761
1 rows fetched
adrci> SET CONTROL (SHORTP_POLICY=168);
adrci> SHOW CONTROL
ADR Home = /app/oracle/diag/rdbms/prddb/PRDDB_1:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME
---------------------------------------- -------------------- ---------------------------
2673816947 168 8760 2010-12-12 19:48:05.604658
1 rows fetched
adrci>

V$DIAG_ADR_CONTROL
The short-term policy and the long-term policy parameters, along with other control information, can be viewed from
inside the database using this view:

Script Name: MVRACPDnTap_adrcontrol.sql
Short Pck Long Pck
ADR Home Policy Policy
------------------------------------------ --------- --------
diag/asm/+asm/+ASM1 720 8760
diag/rdbms/prddb/PRDDB_1 168 8760
diag/tnslsnr/prddb1/listener 720 8760
diag/tnslsnr/prddb1/listener_scan1 720 8760
diag/tnslsnr/prddb1/listener_scan2 720 8760
diag/tnslsnr/prddb1/listener_scan3 720 8760

■ in the preceding output, the short-term purge (retention policy) has been modified to 7 days or 168 hours.
similarly, the retention policy for the long-term files can also be modified by setting the parameter LONGP_POLICY .

Note

because these control parameters apply to each aDr home, in a raC environment, these changes have to be made
separately for each aDr home.