Oracle 日志

最新推荐文章于 2024-10-12 17:08:35 发布

PostgreSQL_0

最新推荐文章于 2024-10-12 17:08:35 发布

阅读量100

点赞数

分类专栏： Oracle 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/weixin_44089900/article/details/128043967

版权

Oracle 专栏收录该内容

43 篇文章 3 订阅

订阅专栏

oracle监控，查看v$diag_info

SQL> set line 200
SQL> col name for a30
SQL> col value for a50
SQL> select * from v$diag_info;

   INST_ID NAME                           VALUE                                                  CON_ID
---------- ------------------------------ -------------------------------------------------- ----------
         1 Diag Enabled                   TRUE                                                        0
         1 ADR Base                       /inspur/app/oracle                                          0
         1 ADR Home                       /inspur/app/oracle/diag/rdbms/prod/PROD                     0
         1 Diag Trace                     /inspur/app/oracle/diag/rdbms/prod/PROD/trace               0
         1 Diag Alert                     /inspur/app/oracle/diag/rdbms/prod/PROD/alert               0
         1 Diag Incident                  /inspur/app/oracle/diag/rdbms/prod/PROD/incident            0
         1 Diag Cdump                     /inspur/app/oracle/diag/rdbms/prod/PROD/cdump               0
         1 Health Monitor                 /inspur/app/oracle/diag/rdbms/prod/PROD/hm                  0
         1 Default Trace File             /inspur/app/oracle/diag/rdbms/prod/PROD/trace/PROD          0
                                          _ora_53249.trc


   INST_ID NAME                           VALUE                                                  CON_ID
---------- ------------------------------ -------------------------------------------------- ----------
         1 Active Problem Count           0                                                           0
         1 Active Incident Count          0                                                           0
         1 ORACLE_HOME                    /inspur/app/oracle/product/19.3.0/dbhome_1                  0

12 rows selected.
##说明
Diag Alert 实例警告日志
Diag Incident 
Diag Trace
Diag Alert 警告日志
Default Trace File 当前会话跟踪