系统错误日志-SYS_ALL_ERROR_LOG
📄字数 601
👁️阅读量 加载中...
功能描述
SYS_ALL_ERROR_LOG系统表用于查询所有节点的系统错误日志信息，通过读取所有节点的ERROR.LOG日志文件的内容进行展示。
字段说明
应用举例
sql
SQL> SELECT 'test123'::INT FROM DUAL;
Error: [E17003 L1 C8] 数据格式错
SQL> SELECT * FROM SYS_ALL_ERROR_LOG ORDER BY EX_TIME DESC LIMIT 1;
+--------+----------+--------+----------+--------------------------+---------------+--------+-------+------------+----------------------------------+
| NODEID | EX_LEVEL | ERR_NO | ERR_CODE | EX_TIME | CLIENT_IP | USER | DB_ID | ERR_STR | SQL_STR |
+--------+----------+--------+----------+--------------------------+---------------+--------+-------+------------+----------------------------------+
| 1 | ERROR | 71 | 17003 | 2025-06-28 16:04:37.000 | 192.168.2.236 | SYSDBA | 1 | 数据格式错 | SELECT 'test123'::INT FROM DUAL; |
+--------+----------+--------+----------+--------------------------+---------------+--------+-------+------------+----------------------------------+
-- 2号节点执行报错语句
SQL> EXEC test1();
Error: [E10012] 过程或函数TEST1不存在
-- 1号节点查询
SQL> SELECT * FROM SYS_ALL_ERROR_LOG WHERE NODEID=2 ORDER BY EX_TIME DESC LIMIT 1;
+--------+----------+--------+----------+--------------------------+---------------+--------+-------+-----------------------+---------------+
| NODEID | EX_LEVEL | ERR_NO | ERR_CODE | EX_TIME | CLIENT_IP | USER | DB_ID | ERR_STR | SQL_STR |
+--------+----------+--------+----------+--------------------------+---------------+--------+-------+-----------------------+---------------+
| 2 | ERROR | 330 | 10012 | 2025-06-28 16:22:20.000 | 192.168.2.236 | SYSDBA | 1 | 过程或函数TEST1不存在 | EXEC test1(); |
+--------+----------+--------+----------+--------------------------+---------------+--------+-------+-----------------------+---------------+