1. Information on automatic diagnostic repositry(ADR) directories used by Data recovery advisor stored outside the database
SQL> select name,value from v$diag_info;
NAME VALUE
---------------------------------------------------------------- --------------------------------------------------
Diag Enabled TRUE
ADR Base /u01/app/orcl/oracle
ADR Home /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman
Diag Trace /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/trac
e
Diag Alert /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/aler
t
Diag Incident /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/inci
dent
Diag Cdump /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/cdum
p
Health Monitor /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/hm
Default Trace File /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/trac
e/cvrman_ora_2407.trc
Active Problem Count 0
Active Incident Count 0
11 rows selected.
No comments:
Post a Comment