ADRCI - quick reference
f:\oracle\product\11.2.0\dbhome_1\BIN>adrci
--
ADRCI: Release 11.2.0.2.0 - Production on Wed Jun 29 09:59:34 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "F:\ORACLE"
adrci> show homes
ADR Homes:
diag\clients\user_oracleadmin\host_3607073977_80
diag\clients\user_oracleadmin\host_3607073977_82
diag\clients\user_SYSTEM\host_3607073977_80
diag\rdbms\cdb1dev\cdb1dev
diag\rdbms\appl2dv1\appl2dv1
diag\rdbms\appl2dv2\appl2dv2
diag\rdbms\appl2udv\appl2udv
diag\rdbms\appl4dev\appl4dev
diag\rdbms\appldev\appldev
diag\rdbms\dwbidev\dwbidev
diag\rdbms\odsbi2dv\odsbi2dv
diag\tnslsnr\devacwdb308\listener


-- purge in minutes 1440 for 1 day, 10080 for 7 days
adrci> purge -age 15000
DIA-48448: This command does not support multiple ADR homes

adrci> set homepath diag\rdbms\appldev\appldevdiag\rdbms\appldev\appldev
DIA-48447: The input path [diag\rdbms\appldev\appldevdiag\rdbms\appldev\appldev] does not contain any ADR homes

adrci> set homepath diag\rdbms\appldev
adrci> purge -age 1500
adrci> set homepath diag\rdbms\odsbi2dv\odsbi2dv
adrci> purge -age 1
adrci> set homepath diag\rdbms\dwbidev\dwbidev
adrci> purge -age 1
adrci> set homepath diag\rdbms\appl4dev\appl4dev
adrci> purge -age 1
adrci>


COLUMN name FORMAT A25
COLUMN value FORMAT A65

SELECT name, value FROM v$diag_info;

NAME                      VALUE
------------------------- -----------------------------------------------------------------
Diag Enabled              TRUE
ADR Base                  /u01/app/oracle
ADR Home                  /u01/app/oracle/diag/rdbms/orcl/orcl
Diag Trace                /u01/app/oracle/diag/rdbms/orcl/orcl/trace
Diag Alert                /u01/app/oracle/diag/rdbms/orcl/orcl/alert
Diag Incident             /u01/app/oracle/diag/rdbms/orcl/orcl/incident
Diag Cdump                /u01/app/oracle/diag/rdbms/orcl/orcl/cdump
Health Monitor            /u01/app/oracle/diag/rdbms/orcl/orcl/hm
Default Trace File        /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_19975.trc
Active Problem Count      0
Active Incident Count     0

11 rows selected.