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