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