Oracle：v$diag_info
“v$diag_info”是Oracle database 11g之后新引入的一张视图，它的内容包含了很重要的ADR（自动诊断资料库）的位置。
具体情况如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
SQL> desc v$diag_info Name Null? Type ----------------------------------------- -------- ---------------------------- INST_ID NUMBER NAME VARCHAR2(64) VALUE VARCHAR2(512) SQL> SQL> select * from v$diag_info; INST_ID NAME VALUE ---------- ----------------------- ------------------------------------------------------------ 1 Diag Enabled TRUE 1 ADR Base /u01/app/oracle 1 ADR Home /u01/app/oracle/diag/rdbms/orcl/orcl 1 Diag Trace /u01/app/oracle/diag/rdbms/orcl/orcl/trace 1 Diag Alert /u01/app/oracle/diag/rdbms/orcl/orcl/alert 1 Diag Incident /u01/app/oracle/diag/rdbms/orcl/orcl/incident 1 Diag Cdump /u01/app/oracle/diag/rdbms/orcl/orcl/cdump 1 Health Monitor /u01/app/oracle/diag/rdbms/orcl/orcl/hm 1 Default Trace File /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4542.trc 1 Active Problem Count 0 1 Active Incident Count 0 11 rows selected. SQL> |
——————————————————————————
Endin[……]
- Posted on:
-
Author:
Adamhuan
- Categories: Oracle Database
- Tags: 11g, ADR, Oracle, v$diag_info, 自动诊断
- Leave a comment: Oracle：v$diag_info