Queries to view Alert Log content And Alert Location
来源:互联网 发布:tri0数据 什么意思 编辑:程序博客网 时间:2024/05/08 13:26
Quering alert log using SQL query
Oracle 11g开始,提供了X$DBGALERTEXT,可以用来使用sql访问数据库alert日志,在不方便直接访问服务器时,提供了另外的方式访问数据库alert日志。X$DBGALERTEXT的定义如下:
SYS> desc X$DBGALERTEXT Name Null? Type ----------------------------------------------------------------------------------- -------- -------------------------------------------------------- ADDR RAW(8) INDX NUMBER INST_ID NUMBER ORIGINATING_TIMESTAMP TIMESTAMP(3) WITH TIME ZONE NORMALIZED_TIMESTAMP TIMESTAMP(3) WITH TIME ZONE ORGANIZATION_ID VARCHAR2(64) COMPONENT_ID VARCHAR2(64) HOST_ID VARCHAR2(64) HOST_ADDRESS VARCHAR2(46) MESSAGE_TYPE NUMBER MESSAGE_LEVEL NUMBER MESSAGE_ID VARCHAR2(64) MESSAGE_GROUP VARCHAR2(64) CLIENT_ID VARCHAR2(64) MODULE_ID VARCHAR2(64) PROCESS_ID VARCHAR2(32) THREAD_ID VARCHAR2(64) USER_ID VARCHAR2(64) INSTANCE_ID VARCHAR2(64) DETAILED_LOCATION VARCHAR2(160) PROBLEM_KEY VARCHAR2(64) UPSTREAM_COMP_ID VARCHAR2(100) DOWNSTREAM_COMP_ID VARCHAR2(100) EXECUTION_CONTEXT_ID VARCHAR2(100) EXECUTION_CONTEXT_SEQUENCE NUMBER ERROR_INSTANCE_ID NUMBER ERROR_INSTANCE_SEQUENCE NUMBER VERSION NUMBER MESSAGE_TEXT VARCHAR2(2048) MESSAGE_ARGUMENTS VARCHAR2(128) SUPPLEMENTAL_ATTRIBUTES VARCHAR2(128) SUPPLEMENTAL_DETAILS VARCHAR2(128) PARTITION NUMBER RECORD_ID NUMBER
比较常用的SQL如下(可以得到类似直接访问文本格式alert日志样式的结果):
SQL> select ORIGINATING_TIMESTAMP, MESSAGE_TEXT from X$DBGALERTEXT;
Finding Trace File Path using SQL
11g开始,Oracle提供了X$DBGDIREXT接口,可以用来查看diagnostic_dest下的目录和文件。X$DBGDIREXT的定义如下:
SYS> desc X$DBGDIREXT; Name Null? Type ----------------------------------------------------------------------------------- -------- -------------------------------------------------------- ADDR RAW(8) INDX NUMBER INST_ID NUMBER PHYSICAL_PATH VARCHAR2(444) LOGICAL_PATH VARCHAR2(444) PHYSICAL_FILE VARCHAR2(68) LOGICAL_FILE VARCHAR2(68) CREATION_TIME TIMESTAMP(3) WITH TIME ZONE MODIFY_TIME TIMESTAMP(3) WITH TIME ZONE LVL NUMBER TYPE NUMBER
一个非常handy的用法:有时候不熟悉Oracle的人,我们需要它帮忙把alert日志取出来的时候,由于11g的alert是放在diagnostic中的,描述日志的路径每次都要费很大的劲,现在我们可以用下面sql来直接获取到alert日志的路径了:
SELECT PHYSICAL_PATH || CHR(47) || PHYSICAL_FILE FROM X$DBGDIREXT WHERE 1 = 1 AND PHYSICAL_FILE LIKE 'alert_%' AND PHYSICAL_PATH LIKE '%rdbms%'/
0 0
- Queries to view Alert Log content And Alert Location
- Location of alert.log file
- file.alert - log alert to a file
- 124.You executed the following commands to find the location of the alert log file: SQL> SHOW PARAME
- Alert log - Oracle FAQ
- Oracle's alert.log
- Oracle's alert.log
- oracle alert.log位置
- alert 和 console.log
- Oracle-Alert log解读
- console.log与alert
- Alert
- Alert
- alert
- alert
- alert();
- Alert
- Alert
- eclipse配置字体、背景颜色
- python 装饰器 理解 这里一直没太理解 装饰器是个怎么回事
- qiniudn.com域名已完全恢复
- .net后台输出渐变饼图(基于highcharts)
- 常用编码详解
- Queries to view Alert Log content And Alert Location
- 《C语言及程序设计》实践参考——分离整数和小数部分
- 给Repeater控件里添加序号的5种方法
- 《C语言及程序设计》实践参考——如何买玫瑰?
- 《C语言及程序设计》实践参考——玩数字
- Nodejs学习路线图
- Registry
- 【ExtJS】Cannot call method 'removeCls'或'addCls' of null
- 《C语言及程序设计》实践参考——坐标转换