系统追踪日志-SYS_ALL_TRACE_LOG
📄字数 481
👁️阅读量 加载中...
功能描述
SYS_ALL_TRACE_LOG系统表用于查询所有节点的系统追踪的事件日志信息，通过读取所有节点的TRACE.LOG日志文件的内容进行展示。
字段说明
补充示例
- 在2号节点查询1号节点事务日志信息
sql
SQL> SELECT * FROM SYS_ALL_TRACE_LOG WHERE NODEID=1 ORDER BY trace_time DESC LIMIT 4;
+--------+-------+------------+--------------------------+----------------------------------------------------------+
| NODEID | DB_ID | TRACE_TYPE | TRACE_TIME | TRACE_STR |
+--------+-------+------------+--------------------------+----------------------------------------------------------+
| 1 | 6 | RESTORE | 2025-06-30 09:52:34.000 | import table SYSDBA.TAB_TRACE data row 0 |
| 1 | 5 | BACKUP | 2025-06-30 09:50:09.000 | export table TAB_TRACE rows 0 |
| 1 | 5 | BACKUP | 2025-06-30 09:50:09.000 | backup database DB_REG_TRACE finish |
| 1 | 5 | BACKUP | 2025-06-30 09:50:09.000 | Backup database DB_REG_TRACE to /BACKUP/BACKUP.exp start |
+--------+-------+------------+--------------------------+----------------------------------------------------------+